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 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;