You should be able to look at view dba_tab_privs to see who granted the
execute to public. If you are a DBA, you should be able to revoke the
privilege regardless of who granted the privilege.

IJCA,
Gil Bruce

-----Original Message-----
From: Sikyala Raquel
[mailto:oracledba-ezmlmshield-x8264220.[Email address protected]
Sent: Friday, September 28, 2007 11:09 AM
To: LazyDBA Discussion
Subject: problem with revoke command

When I try to revoke execute on <object_name> from public I get an error
message that I can't revoke priv I didn't grant. How can I get this
command to execute successfully? Do I need to find out who granted the
privilege then as that person use the revoke command?


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page