Database Administration (MOSC)

MOSC Banner

Why aren't grants on mutable objects shown in dba_tab_privs?

Hello Community!

My question is:

Why aren't grants on mutable objects shown in dba_tab_privs?

If I grant USER2 "KEEP SEQUENCE" on USER1's sequence like this:

grant KEEP SEQUENCE on USER1.MySEQ to USER2;

I can't see that grant in DBA_TAB_PRIVS.

Why?

Where can I see the grant?

Thanks in advance,

Hasse

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