DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: How to audit create user and drop user privs ?

  1. #1
    Join Date
    Aug 2002
    Posts
    15

    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

  2. #2
    Join Date
    Oct 2002
    Location
    Ljubljana,Slovenia
    Posts
    28
    Try auditing create,drop and audit user stmt

    AUDIT CREATE USER
    AUDIT ALTER USER
    AUDIT DROP USER
    Aleš Orehek

  3. #3
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    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
  •  


Click Here to Expand Forum to Full Width