PBU's notes
May 9, 2018
Create 'DENY SELECT TABLE To [USER]' query in T-SQL
--ALL TABLE DENY TO USER
DECLARE @USERID NVARCHAR(20)
SET @USERID = 'UserID'
SELECT 'DENY SELECT ON '+NAME+' TO '+'['+@USERID+']' FROM SYS.TABLES
WHERE SCHEMA_ID = 1
ORDER BY NAME
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment