OraFAQ Forum: Security » REVOKE doesnot work

Home » RDBMS Server » Security » REVOKE doesnot work

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

REVOKE doesnot work [message #117646]

Thu, 28 April 2005 13:38

jv68
Messages: 8
Registered: March 2005
Location: Charlotte

Junior Member

HI,

I am giving 'REVOKE select On xxxx from user1'
as administrator.

Then when I login in user1 I am still able to select records from the table. How do I restrict him from seeing the records. Help needed.

Thanks
Joe.

Report message to a moderator

Re: REVOKE does not work [message #117655 is a reply to message #117646]

Thu, 28 April 2005 14:39

Frank Naude
Messages: 4575
Registered: April 1998

Senior Member

Hi,

Connect to user1 and do a select * from session_privs/ session_privs to see what other privileges this user has. For example, the "SELECT ANY TABLE" privilege overwrites all object grants/revokes.

Best regards.

Frank

Report message to a moderator

Re: REVOKE does not work [message #117660 is a reply to message #117655]

Thu, 28 April 2005 14:52

jv68
Messages: 8
Registered: March 2005
Location: Charlotte

Junior Member

Hi frank,

There is public synonym on the table. In which case, how can I restrict the user from selecting records from this table. Just for couple of users I want to rectrict access to the table.

thanks

Report message to a moderator

Re: REVOKE does not work [message #117662 is a reply to message #117660]

Thu, 28 April 2005 15:07

Frank Naude
Messages: 4575
Registered: April 1998

Senior Member

No, it's not that one! The existence of a public synonym does not imply that other users can select from the table.

Best regards.

Frank

Report message to a moderator

Previous Topic:	profile of user...
Next Topic:	table access query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 17:05:46 CDT 2023