Answers

Question and Answer:

  Home  Oracle Database

⟩ How To Find Out What Privileges a User Currently Has in Oracle?

Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on those views as shown in the tutorial exercise below:

>.insqlplus /nolog

SQL> CONNECT DEV/developer

SQL> SELECT username, privilege FROM USER_SYS_PRIVS;

USERNAME     PRIVILEGE

------------------------------ ----------------------

DEV SELECT ANY TABLE

DEV INSERT ANY TABLE

DEV CREATE SESSION

DEV CREATE VIEW

DEV DELETE ANY TABLE

DEV CREATE ANY TABLE

SQL> disconnect

SQL> connect SYSTEM/globalguideline

 120 views

More Questions for you: