Re: Table Revoke Frustration!!
Date: Wed, 21 Oct 2009 14:29:50 -0400
Message-ID: <49d668000910211129g76db1227vc133f5a6eae34895_at_mail.gmail.com>
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
<JEREMY.SHEEHAN_at_nexteraenergy.com> wrote:
> Good idea. Unfortunately, I tried it and it didn't work.
>
> Jeremy
> 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