Take the 2-minute tour ×

I have a situation like this. I have schema which has high level user 'db1owner' and low level user 'db1user'.

'db1owner' has grant some permissions to view, table, and other schema objects for 'db1user'.

Now I want to know the list of objects which all grant by 'db1owner' with permission details.

How can find it?

Any help indeed!


share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Take a look at the ALL_TAB_PRIVS data dictionary table.

Something like....

WHERE  GRANTOR = 'db1owner'
AND    GRANTEE = 'db1user'

Description of ALL_TAB_PRIVS:


share|improve this answer
add comment

Your Answer


