How to audit create user and drop user privs ?
I have enabled auditing and want to check who is using "create user" and "drop user" privs ?
Plz let me know how to do this ?
Try auditing create,drop and audit user stmt
AUDIT CREATE USER
AUDIT ALTER USER
AUDIT DROP USER
or you can execute
AUDIT CREATE USER BY ACCESS WHENEVER SUCCESSFUL
AUDIT CREATE USER BY ACCESS WHENEVER NOT SUCCESSFUL
AUDIT CREATE USER BY SESSION
Are you suspicious of administrators or normal users?
Which parameter(s) did you enable?...
for more detail
Able was I ere I saw Elba
Click Here to Expand Forum to Full Width