How to find privileges and roles granted to a user in oracle

Question

273 views03/10/2022Oracle Database

0

AB (anonymous) 02/10/2022 0 Comments

How to find privileges and roles granted to a user in oracle?

Ezana Answered question 03/10/2022

Write your answer.

score 0 · Answer 1 · 2022-10-03T18:09:16+00:00

We can use the following scripts to find privileges and roles granted to a user in oracle:

select privilege 
from dba_sys_privs 
where grantee='Mereba' 
order by 1;

where “mereba” is the oracle user.