Re: Unable to revoke privileges from a user

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Fri, 5 Mar 2004 07:00:32 -0500
Message-ID: <Se2dnUqz1Ol_9tXdRVn-hA@comcast.com>

"Denis Martineau" <martineaude_at_hotmail.com> wrote in message news:27314556.0403041435.ec1f88f_at_posting.google.com...
| Some user accounts have been created some time ago and we have just
| found out that they were given privileges they should not have.
| However, I have no idea which account was used to create them and when
| I use a DBA account to revoke these privileges I get the following
| message: "ORA-01927: cannot REVOKE privileges you did not grant"
|
| Any idea how to revoke these accesses?

only the owner of an object can grant/revoke object privileges (this is why roles are such a good idea)

connect as the owner of the object and you will have certain success

(the same is not true for system privileges)

;-{ mcs Received on Fri Mar 05 2004 - 06:00:32 CST