Monday, January 3, 2011

Checking Privileges

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';

No comments: