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

yakub21 Nov 8, 2012 12:52 PM

Currently Being Moderated

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 1:03 PM (in response to yakub21)

Currently Being Moderated

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
Report Abuse

Like (0)

Actions

Stop tracking
Track in Communications

Legend

Correct Answers - 10 points
Helpful Answers - 5 points