RE: Table Revoke Frustration!!

From: POWELL, MARK <mark.powell2_at_hp.com>
Date: Wed, 21 Oct 2009 18:33:22 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415933A5B1CCD2B_at_GVW1337EXC.americas.hpqcorp.net>

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!!

Jeremy,

Can you do an 'alter session set current_schema=$EUL_SCHEMA' and then issue the revokes?

Joseph D'Antoni
Synthes USA

---

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!!

Hey all,

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 - 9.2.0.8
OS - AIX 5.3.9 Thanks in Advance!

Jeremy
P Consider the environment. Please don't print this e-mail unless you really need to.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Oct 21 2009 - 13:33:22 CDT