Assign Deny Permissions to Specific User

How to deny insert, update, delete, update permissions for a specific user of a specific user database?

Questions by rsurya

Showing Answers 1 - 3 of 3 Answers

bugeye

  • Mar 15th, 2008
 

So what context is the user in?  A role a datareader? Datawriter?
You want no permissions?
USE <your db>
Drop USER <your  user>
 In a role?
EXEC sp_droprolemember 'rolename' , 'Member'

single objects?
Revoke SELECT, INSERT, UPDATE, DELETE ON <object> to <user>

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions