Database Administration (MOSC)

MOSC Banner

ORA-22812 cannot reference nested table column's storage table

edited Feb 13, 2009 6:28AM in Database Administration (MOSC) 2 commentsAnswered
 I granted a privilege to a role for an object.
Grant privilege on table to role

Then I revoked it.

Revoke privilege on table from user

Now I'm getting an ORA-22812 cannot reference nested table column's storage table.

How do I revoke the privilege on a table that contains nested table storage columns?

Thanks for any help you can provide.


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