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

Thread: Is this possible "Alter Any User"

  1. #1
    Join Date
    May 2002
    Posts
    93
    How do I grant this "Alter Any User" to a user? I can grant other privileges but not this one. Is this working at all?

    Create user ABC identified by DFG;
    Grant Alter Any User to ABC;

    Thanks

  2. #2
    Join Date
    Feb 2000
    Location
    NJ, United States
    Posts
    250
    There is no such privilege ALTER ANY USER, check
    dba_sys_privs view:
    select * from dba_sys_privs where privIlege like 'ALTER%USER';
    DBA ALTER USER YES


    You can grant alter user for the same purpose.

    KN

  3. #3
    Join Date
    May 2002
    Posts
    93
    Thanks Knayaran,

    I have been asked with this question, and same here I don't think it exist. You suggestions are what exactly I thought, but would like to find out from the experts out here first. I might have limited knowledge.

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