Re: Table Revoke Frustration!!
Date: Wed, 21 Oct 2009 14:29:50 -0400
I can't think of any other reason from the top of my head right now. Make sure you're indeed revoking something which was granted first :-)
On Wed, Oct 21, 2009 at 2:24 PM, SHEEHAN, JEREMY
> Good idea. Unfortunately, I tried it and it didn't work.
> Consider the environment. Please don't print this e-mail unless you really need to.
> -----Original Message-----
> From: Alex Fatkulin [mailto:afatkulin_at_gmail.com]
> Sent: Wednesday, October 21, 2009 2:08 PM
> To: SHEEHAN, JEREMY
> Cc: ORACLE-L
> Subject: Re: Table Revoke Frustration!!
> If I understood correctly your problem is that you can't do a revoke
> from inside a stored proc? If this is correct then you might be facing
> an "issue" that privileges granted through roles are not in effect
> inside the stored proc. OEM does that through SQL statement, not
> stored proc.
> If you do
> grant grant any object privilege to <the user which does a revoke>
> does the problem remain?
-- Alex Fatkulin, http://afatkulin.blogspot.com http://www.linkedin.com/in/alexfatkulin -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 21 2009 - 13:29:50 CDT