Re: Table Revoke Frustration!!
Date: Wed, 21 Oct 2009 10:59:31 -0700 (PDT)
Message-ID: <135033.84478.qm_at_web59008.mail.re1.yahoo.com>
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
PConsider the environment. Please don't print this e-mail unless
you really need to.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 21 2009 - 12:59:31 CDT