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, privilege, admin_option FROM dba_sys_privs WHERE grantee = UPPER('&USER_OR_SCHEMA_NAME') 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.