Database Administration (MOSC)

MOSC Banner

Show Objects Grants for a role

In an Oracle 12c database I cannot make a query that returns the objects grants of a role. However from the TOAD application I can see this information.

I need a query that shows me the same information as TOAD


Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center