By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,504 Members | 1,903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,504 IT Pros & Developers. It's quick & easy.

Unable to revoke privileges from a user

P: n/a
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?
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ma*********@hotmail.com (Denis Martineau) wrote in
news:27*************************@posting.google.co m:
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
www.emaginetix.com
Jul 19 '05 #2

P: n/a

"Denis Martineau" <ma*********@hotmail.com> wrote in message
news:27*************************@posting.google.co m...
| 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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.