1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Getting Priviledges of user in Oracle/SQL Server

Discussion in 'Oracle' started by go4expert, Aug 20, 2004.

  1. go4expert

    go4expert Moderator

    Joined:
    Aug 3, 2004
    Messages:
    306
    Likes Received:
    7
    Trophy Points:
    0
    I would like to get the priviledges I [or any user] have for the specified database or object. I know the stored procedures like sp_helpuser and sp_helplogins exist for SQL Server but I would like to know the general sql for oracle and/or sql server.
     
  2. Amit Ray

    Amit Ray New Member

    Joined:
    Jul 12, 2004
    Messages:
    75
    Likes Received:
    4
    Trophy Points:
    0
    Occupation:
    Software Developer
    Home Page:
    Re: Getting Privileges of user in Oracle/SQL Server

    Hi ..

    Oracle privileges can be largely classified as : System privileges and Object privileges. The following tables contain all the privilege information in Oracle :

    DBA_SYS_PRIVS : The System Previleges.

    DESC DBA_TAB_PRIVS : The Table Privileges.

    DESC DBA_ROLE_PRIVS : Roles consist of a set of privileges which can be assigned to users instead of granting privileges one by one.

    DESC DBA_COL_PRIVS : The Table Column Privileges.

    The text attachment contains a sample session in a Oracle DB which will make a lot things clear.

    Amit Ray. :cool:
     

    Attached Files:

    Last edited: Aug 28, 2004
  3. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    You can also use sp_helpuser Stored Procedure in SQL Server

    Here is the complete description of it

     

Share This Page