Database Security Products (MOSC)

MOSC Banner

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

edited Feb 18, 2014 12:00PM 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 to My Oracle Support Community.

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