OraFAQ Forum: Security » How to check the privileges given to user

Home » RDBMS Server » Security » How to check the privileges given to user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to check the privileges given to user [message #337572]

Thu, 31 July 2008 05:10

harshkumar
Messages: 34
Registered: February 2008
Location: Delhi

Member

Hi,

How to check which privilege is granted to a particular user.
Which view can be used to check the same.

Thanks
Harsh

Report message to a moderator

Re: How to check the privileges given to user [message #337575 is a reply to message #337572]

Thu, 31 July 2008 05:18

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

There seem to be quite a few dictionary tables related to privileges and grants. Run this to get a list of them :

SELECT * FROM DICTIONARY 
 WHERE Lower(COMMENTS) LIKE '%privilege%' 
   OR  Lower(COMMENTS) LIKE '%grant%'

Report message to a moderator

Re: How to check the privileges given to user [message #337622 is a reply to message #337575]

Thu, 31 July 2008 07:45

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

SQL>SELECT * FROM DBA_USER_PRIVS WHERE USERNAME='SCOTT';

will give privileges assign to user scott.

and if you want to know any particular privileges like create any table is given to any user than

SQL> SELECT * FROM DBA_USER_PRIVS WHERE PRIVILEGE = 'CREATE ANY TABLE';

Report message to a moderator

Re: How to check the privileges given to user [message #337633 is a reply to message #337622]

Thu, 31 July 2008 08:10

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What about object privileges?
What about roles?

Regards
Michel

Report message to a moderator

Re: How to check the privileges given to user [message #338057 is a reply to message #337633]

Sat, 02 August 2008 18:45

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

Best way is to connect your db through toad, in that you will get script of your user with its privileges Shocked

secondly ....u can get create user script of entire DB users through.

SELECT DBMS_METADATA.GET_DDL('USER', username) FROM DBA_users;

Spool the out put....

[Updated on: Sat, 02 August 2008 18:46]

Report message to a moderator