Guest User | Contact

Frequently Asked Questions

Which System privileges have user and schema

Sometimes we need to check certain user has which kind of system privileges. If you are getting any privilege related errors then also we need to check privilege related issue. Using following SQL commands we can check certain user or schema has which kind of system privileges.

SELECT grantee,
FROM   dba_sys_privs
ORDER BY grantee, privilege;

Using above SQL commands we can get exact idea of system privileges of USER. Kindly provide input as Oracle USERNAME or SCHEMA name during command execution. You need DBA role for executing this command.

If you have any doubt, confusion or issue then you can directly contact our support DBA with your unique customer id.

 Last updated Tue, Sep 29 2015 10:46am

Please Wait!

Please wait... it will take a second!