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:
    9
    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:
    http://www.go4expert.com
    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,375
    Likes Received:
    388
    Trophy Points:
    83
    You can also use sp_helpuser Stored Procedure in SQL Server

    Here is the complete description of it

     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice