Oracle SQL Query to Find User Permissions

Question

Question

OviliaExplorer

Asked: March 6, 20222022-03-06T23:07:53+03:00 2022-03-06T23:07:53+03:00In: Oracle SQL

I need some help to find the current user login permissions he/she has.

You must login to add an answer.

Need An Account,

Hassan AbdElrahman · Accepted Answer · 2022-03-09T23:07:48+03:00

To check current user permission in oracle execute the following queries:

First Query:

SELECT *
FROM USER_SYS_PRIVS
WHERE USERNAME = USER;

The result of this query would be:

Second Query:

SELECT *
FROM USER_TAB_PRIVS
WHERE GRANTEE = USER;

The result of this query would be:

GRANTEE	OWNER	TABLE_NAME	GRANTOR	PRIVILEGE	GRANTABLE	HIERARCHY
HR	SYS	DBMS_STATS	SYS	EXECUTE	NO	NO

Third Query:

SELECT *
FROM USER_ROLE_PRIVS
WHERE USERNAME = USER;

The result of this query would be:

USERNAME	GRANTED_ROLE	ADMIN_OPTION	DEFAULT_ROLE	OS_GRANTED
HR	RESOURCE	NO	YES	NO

hope this help.