Home » RDBMS Server » Security » REVOKE doesnot work
REVOKE doesnot work [message #117646] Thu, 28 April 2005 13:38 Go to next message
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.

Re: REVOKE does not work [message #117655 is a reply to message #117646] Thu, 28 April 2005 14:39 Go to previous messageGo to next message
Frank Naude
Messages: 4579
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
Re: REVOKE does not work [message #117660 is a reply to message #117655] Thu, 28 April 2005 14:52 Go to previous messageGo to next message
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
Re: REVOKE does not work [message #117662 is a reply to message #117660] Thu, 28 April 2005 15:07 Go to previous message
Frank Naude
Messages: 4579
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
Previous Topic: profile of user...
Next Topic: table access query
Goto Forum:
  


Current Time: Fri Mar 29 01:02:01 CDT 2024