RE: Table Revoke Frustration!!
- From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: Alex Fatkulin <afatkulin@xxxxxxxxx>
- Date: Wed, 21 Oct 2009 14:24:51 -0400
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?
>
> 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
��i��0���zX���+�� n��{�+i�^
Other related posts: