RE: Table Revoke Frustration!!
Date: Wed, 21 Oct 2009 18:33:22 +0000
Aren't the Discoverer EUL tables granted to PUBLIC?
If the users are gone why are you not performing a drop user x?
Or at the very least why not lock the user accounts then you can leave the associated privileges in place without worry the privileges will be used.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY Sent: Wednesday, October 21, 2009 2:02 PM To: 'jdanton1_at_yahoo.com'; 'oracle-l_at_freelists.org' Subject: Re: Table Revoke Frustration!!
Tried that. No such luck.
From: Joey D'Antoni <jdanton1_at_yahoo.com> To: SHEEHAN, JEREMY; oracle-l_at_freelists.org <oracle-l_at_freelists.org> Sent: Wed Oct 21 13:59:31 2009
Subject: Re: Table Revoke Frustration!!
Can you do an 'alter session set current_schema=$EUL_SCHEMA' and then issue the revokes?
From: "SHEEHAN, JEREMY" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: "oracle-l_at_freelists.org" < >
Sent: Wed, October 21, 2009 1:49:04 PM
Subject: Table Revoke Frustration!!
I'm working on a little something where I need to revoke all access given to users that are no longer with the company. Roles are no problem. I keep on having issues with tables, though.
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?
RDBMS - 220.127.116.11
OS - AIX 5.3.9 Thanks in Advance!
P Consider the environment. Please don't print this e-mail unless you really need to.