Frequently Asked Questions
Check object privileges of certain user or schema
In routine use, we need to get exact idea of which type of object privilege is having which user. Sometimes for copying or creating same kind of privileges to new user we need to get detail of this object privileges. Using following SQL commands we can get exact idea that certain user has which kind of privileges on which object.
select owner,table_name,grantor,privilege from dba_tab_privs where grantee='&USER_NAME'
In above command provide required username or schema name in USER_NAME variable.