-
How to audit create user and drop user privs ?
Hi,
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 ?
Thanks,
Sal
-
Try auditing create,drop and audit user stmt
AUDIT CREATE USER
AUDIT ALTER USER
AUDIT DROP USER
Aleš Orehek
-
or you can execute
AUDIT CREATE USER BY ACCESS WHENEVER SUCCESSFUL
AUDIT CREATE USER BY ACCESS WHENEVER NOT SUCCESSFUL
OR
AUDIT CREATE USER BY SESSION
Are you suspicious of administrators or normal users?
Which parameter(s) did you enable?...
1.AUDIT_SYS_OPERATIONS=TRUE
2.AUDIT_TRAIL=DB/OS
3.GOTO
http://download-west.oracle.com/docs...t.htm#ADMIN026
for more detail
Able was I ere I saw Elba
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|