Database Tuning (MOSC)

MOSC Banner

NOAUDIT create session for a specif user

after executing

noaudit create session by MY_USER whenever successful;


my audit destination is still plenty of audit file regarding logon of MY_USER


i.e.

LENGTH: "431"

SESSIONID:[9] "562277048" ENTRYID:[1] "1" STATEMENT:[1] "1" USERID:[14] "MY_USER" USERHOST:[8] "myhostname" TERMINAL:[7] "unknown" ACTION:[3] "100" RETURNCODE:[1] "0" COMMENT$TEXT:[140] "Authenticated by: DATABASE;AUTHENTICATED IDENTITY: MY_USER; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=xx.xx.xx.xx)(PORT=35529))" OS$USERID:[5] "osusername" DBID:[9] "dbid" PRIV$USED:[1] "5" CURRENT_USER:[14] "MY_USER"


is that correct ?

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