Guest User | Contact

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.

 Last updated Tue, Sep 29 2015 10:46am

Please Wait!

Please wait... it will take a second!