Find out the user and its privileges in Oracle

Find out the user and its privileges in Oracle

Check all user having sys privileges

select * from V$PWFILE_USERS;

Check all system privileges granted related to all users/roles.


GRANTEE is the name, role, or user that was assigned the privilege.
PRIVILEGE is the privilege that is assigned.
ADMIN_OPTION indicates if the granted privilege also includes the ADMIN option.

Check object level privileges to User

select * from DBA_TAB_PRIVS;

GRANTEE is the name of the user with granted access.
TABLE_NAME is the name of the object (table, index, sequence, etc).
PRIVILEGE is the privilege assigned to the GRANTEE for the associated object.

Check all the roles granted to users/roles

select * from dba_role_privs;

Check all the column level privileges for user/role


Find out current user permissions

-- your permissions
select * from USER_ROLE_PRIVS where USERNAME = USER;
select * from USER_TAB_PRIVS where GRANTEE = USER;
select * from USER_SYS_PRIVS where USERNAME = USER;

2 thoughts on “Find out the user and its privileges in Oracle

  1. Alex

    You actually make it seem really easy together with your presentation however I find this matter to be actually something that I believe I would by no means understand. It kind of feels too complicated and very large for me. I am taking a look ahead to your next publish, I will attempt to get the grasp of it!



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.