Re: Table Revoke Frustration!!
- From: Alex Fatkulin <afatkulin@xxxxxxxxx>
- To: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- 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
<JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxx]
> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
