How to check oracle user privillege

here the simple SQL script to check the user privilege and role on Oracle.

Scenario is you already has oracle user and want to check whether the user has privilege as requested for operation.

Using SQLplus connect using that user and run following SQL script:

SELECT * FROM USER_SYS_PRIVS;   
SELECT * FROM USER_TAB_PRIVS;   
SELECT * FROM USER_ROLE_PRIVS; 

Here the output:







Hope it is helpful.