An error has occurred. For more details please view "logs/errors.log".

An error has occurred. For more details please view "logs/errors.log".

An error has occurred. For more details please view "logs/errors.log".

An error has occurred. For more details please view "logs/errors.log".

An error has occurred. For more details please view "logs/errors.log".

How to check which privileges I have - Knowledge Base: Dbametrix Client Support Desk-2
How to check which privileges I have
.How to check which privileges I have.

After connecting to the database, this query raised in mind of the application developer. Which privileges am I having?

You can see your all privileges using a simple query in SQL*Plus or any other tool. Use following query for getting the result.

SQL>select * from session_privs;

You would get list of your all privileges except object privileges.
Check here an example

SQL> SELECT *
2 FROM session_privs;
PRIVILEGE
----------------------------------------
ALTER SYSTEM
CREATE SESSION
ALTER SESSION
CREATE TABLE

You want particular result then you can use following queries.

SELECT * FROM USER_SYS_PRIVS;
SELECT * FROM USER_TAB_PRIVS;
SELECT * FROM USER_ROLE_PRIVS;
SELECT * FROM ALL_TAB_PRIVS;
Last Updated: 13 Jun 2018

An error has occurred. For more details please view "logs/errors.log".

An error has occurred. For more details please view "logs/errors.log".