SQL Server Deny all users from a table except for one user

sql-server permissions database-permissions
nixgadget picture nixgadget · Aug 7, 2013 · Viewed 13.7k times · Source

Im not too familiar with SQL Server. Can one of you experts please help me with this !

Ive got a table where I want to stop everyone from making changes (Select is fine) except for one user who can read and write to it.

So far Ive got the following to give the user access,

GRANT SELECT, INSERT, UPDATE, DELETE ON [dbo].[RAckNakLog] TO [svc-eR]

How do I stop everyone else from writing to it ?

Answer

Luis LL picture Luis LL · Aug 7, 2013

just the opposite:

DENY INSERT, UPDATE, DELETE ON [dbo].[RAckNakLog] TO [svc-eR]

If you already granted access to a user you need to revoke them (like delete GRANT or DENY)

REVOKE INSERT, UPDATE, DELETE ON [dbo].[RAckNakLog] TO [svc-eR]

Related questions

SQL Server Disabling All Triggers - Cannot find the object "XXXX" because it does not exist or you do not have permissions

I'm trying to run this command in SQL Server: disable trigger all on MYDB This is failing for me. The account I'm logged into has access to MYDB and I've pretty much giving it every single permission available (it's a …

Read More
SQL Server: permissions to read database diagrams

Could you please advise, what are permissions required to give user access to read Database diagrams in SQL Server 2005? Thanks a lot!

Read More
GRANT EXECUTE to all stored procedures

Does the following command effectively give the user, "MyUser," permission to execute ALL stored procedures in the database? GRANT EXECUTE TO [MyDomain\MyUser]

Read More