May 8, 2018

Deny and grant table permission to user in SQL Server

--DENY TABLE SELECT PERMISSION TO USER
DENY SELECT ON TABLENAME TO [USERID]

--GRANT TABLE SELECT PERMISSION TO USER
GRANT SELECT ON TABLENAME TO [USERID]

No comments:

Post a Comment