1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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,276
    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