Geek Answers Handbook

Extract user USER GRANTS in ORACLE DB 11g

I need to reset the USER, and I need to get all the grants that I gave to this user.

I tried to request USER_TAB_PRIVS, but I saw something was missing, for example, a grant on an external table or to create a synonym.

Can anyone give me a hint on how to get a complete list of grants?

I mean grants for an object, a table and other resources?

Many thanks!

+4
source share
1 answer

DBA_TAB_PRIVS - to which users / roles are granted, to which object privileges are granted (select on user2.table)

DBA_SYS_PRIVS - to which users / roles are granted, what system privileges (create a session, delete any table, etc.)

DBA_ROLES - who are provided with users / roles whose roles

+6
source

More articles:


All Articles