Re: Table Revoke Frustration!!
From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 21 Oct 2009 14:08:28 -0400
Message-ID: <49d668000910211108i10aa798dtc4bbba7255b06d2b_at_mail.gmail.com>
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.
Date: Wed, 21 Oct 2009 14:08:28 -0400
Message-ID: <49d668000910211108i10aa798dtc4bbba7255b06d2b_at_mail.gmail.com>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 21 2009 - 13:08:28 CDT