Home » RDBMS Server » Security » Grant privileges
Grant privileges [message #178005] Mon, 19 June 2006 00:58 Go to next message
Anisasama
Messages: 17
Registered: June 2006
Location: karachi, Pakistan
Junior Member

I had privileged the select grant to user. How I can revert the privilege of selection

[Updated on: Mon, 19 June 2006 00:59]

Report message to a moderator

Re: Grant privileges [message #178015 is a reply to message #178005] Mon, 19 June 2006 01:57 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Revert? Do you mean how to disable this user from selecting data? If so, you'd use REVOKE:

> REVOKE SELECT ON some_table FROM this_user;
Re: Grant privileges [message #178141 is a reply to message #178015] Mon, 19 June 2006 10:00 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


Better to give the snapshot of commands that you used to assign the grants so that others can reply with complete replies.

Otherwise only guess work is left like Littlefoot did and gave you some assumed solution.
Previous Topic: test
Next Topic: history of users
Goto Forum:
  


Current Time: Fri Mar 29 08:16:53 CDT 2024