Re: Unable to revoke privileges from a user
Date: Fri, 5 Mar 2004 07:00:32 -0500
Message-ID: <Se2dnUqz1Ol_9tXdRVn-hA_at_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 - 13:00:32 CET