473,327 Members | 2,012 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Unable to revoke privileges from a user

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
2 11392
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

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: teogra | last post by:
I have written an stored proc that reads from a text file and executes the script as dynamic sql. If the text file contains malicious code,I want to be able to detect it and prevent the stored...
10
by: robwharram | last post by:
Hi, I'm quite frustrated in the fact that I can't even display a simple "Hello World" message on .Net. I've been through all of the groups and searched all over the place and haven't been able...
8
by: cbielins | last post by:
I'm not sure if DB2 has a tool specifically for this, but I was wondering if there's a revoke tool that will completely wipe a group/user off the database without having to revoke from the table...
2
by: killbill | last post by:
Hi All, I am struggling with a problem but no fate till now. I have written a c# program which retrieve X509Certificates associated with Active Directory user. Now i want to revoke a selected...
1
by: srujan | last post by:
Hi, I need a script to provide administrative Privileges to install software from the network and revoke the privileges after installation of that software.I need this to install for the users...
0
by: nemo | last post by:
Hi, I'm able to create, debug, and run ASP.Net projects when I login as a user with admin privileges. However if I logon to the same machine as a user without admin privileges, I get the...
1
by: kalps | last post by:
Hi all, I have logged on into system/manager and created a user and granted some privileges to that user...now i want to connect with that user...i tried the following command connect...
2
by: clearissues | last post by:
Hi All, I have a python script which takes dump of postgres and restores the same. When i take a dump there is no problem. command to take dump: pg_dump -b -c -C --format=c -d -h <<hostname>>...
2
by: Denis Martineau | last post by:
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.