Database Administration (MOSC)
MOSC Banner

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

edited February 2009 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.

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