revoke delete on sys.def$_temp$lob, sys.ol$hints and ol$nodes

yakub21 Nov 8, 2012 8:52 PM

When I do a revoke delete on def$temp$lob from public;
revoke delete on DEF$_TEMP$LOB from public ora-942 table or view does not exist, however the table does exist. Please advise. Thanks

I'm having the same issue with SYS.OL$HINTS and OL$NODES.

1. Re: revoke delete on sys.def$_temp$lob, sys.ol$hints and ol$nodes

Srini Chavali-Oracle Nov 8, 2012 9:03 PM (in response to yakub21)

Pl post details of OS and database versions. What schema are you logged in as when issuing these revoke statements ?

Default Privileges Assigned To PUBLIC [ID 759684.1]

HTH
Srini
Like Show 0 Likes(0)

Actions

Join the world’s largest interactive community dedicated to Oracle technologies.