Database Security Products (MOSC)

MOSC Banner

How do you drop a privilege from a non-existing object?

edited Oct 8, 2009 6:55PM in Database Security Products (MOSC) 17 commentsAnswered ✓
Hi,

I'm trying to revoke a privilege from sys.ext_tables.  We don't use the ext_tables anymore.  I don't know why it shows up as a sys object either, I think this was a mistake.  It was an external table that we no longer use.

I tried:

 revoke select on sys.ext_tables from <user>  force;

and received:

ORA-00942: table or view does not exist

I then tried creating a table and rerunning  the revoke statement with no luck.

Please help,

Faith

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