Unable to revoke privileges from a user

[Denis Martineau]

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?

[Benjamin Hickman]

Re: Unable to revoke privileges from a user

martineaude@hot mail.com (Denis Martineau) wrote in
news:27314556.0 403041435.ec1f8 8f@posting.goog le.com:

ORA-01927: cannot REVOKE privileges you did not grant

Hi,

You should be able to find out which account granted the priveleges by
looking in the dba_tab_privs table.


Regards

Ben

--
Benjamin Hickman

https://www.emaginetix.com

[Mark C. Stock]

Re: Unable to revoke privileges from a user


"Denis Martineau" <martineaude@ho tmail.comwrote in message
news:27314556.0 403041435.ec1f8 8f@posting.goog le.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