Database Security Products (MOSC)
MOSC Banner

MISSING ROWS IN AUDIT TABLE "SYS.AUD$" FOR LOGON EVENT (code 100) USING OS AUTHENTICATION (OPS$ USER

edited February 2014 in Database Security Products (MOSC) 1 commentAnswered

HI, EVERYBODY! RECENTLY I HAVE ACTIVATED AUDIT OVER AN ORACLE DATABASE 9i AND I'M EXPERIMENTING A SUSPICIOUS BEHAVIOR WITH O.S. AUTHENTICATION.
NORMALLY, WHEN IT PRODUCE A LOGON IN THE DATABASE (AND IF THE USER HAVE ACTIVATED AUDIT ON CREATE SESSION), IS INSERTED INTO THE TABLE  "SYS.AUD$" A RECORD WITH A CODE "100" THAT IT BELONG TO "LOGON" EVENT.
IN THE CASE OF USERS AUTHENTICATED ON "O.S." (OPS$ USERS), I DON'T SEE ANY RECORDS WITH AUDIT CODE "100" , ONLY I CAN SEE RECORDS WITH AUDIT EVENT CODE 101 ("LOGOFF" EVENT).
THAT'S CORRECT??  IS THE EXPECTED BEHAVIOR WHEN THE DATABASE IS ACCEDED WITH "OS AUTHENTICATION"?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center