RE: Table Revoke Frustration!!
Date: Wed, 21 Oct 2009 14:24:51 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF0C30CD0F23_at_GOXEXVS03.fplu.fpl.com>
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?
>
> We use Discoverer and privs are granted directly to the users on EUL
> tables. I keep on getting the "ORA-01927: cannot REVOKE privileges you did
> not grant" error. I expected this. However, why is it that I can revoke
> these privs through OEM Grid Control and not via a simple procedure run in
> SQL Plus (conneted as the same user)? Any ideas?
>
--
Alex Fatkulin,
http://afatkulin.blogspot.com
http://www.linkedin.com/in/alexfatkulin
i0zX+ n{+i^ Received on Wed Oct 21 2009 - 13:24:51 CDT