PBU's notes
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment