My colleague having DBA ROLE has created a user for me with the following role.
RESOURCE from his own user.
Then I login and check the detail by using the below query.
select * from DBA_ROLE_PRIVS where grantee = 'MURAHMAN';
It's fine and retrieve all the above three roles, but when I query the
select distinct grantee as "User_Name" from dba_tab_privs;
This does not retrieve my user.
Then I run the below query.
SELECT distinct username, account_status,privilege,owner FROM dba_users left outer join dba_tab_privs on (dba_users.username = dba_tab_privs.grantee) where dba_users.account_status = 'OPEN';
I saw the privilege column against my user is
null? So, could you please help to find the privilege information against each user? Also please explain why the privilege column is
null against my user? All other user have the privilege information.