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