Thursday, July 11, 2013

View Deny Database

-- Step 1
CREATE LOGIN SushilRout WITH PASSWORD='ABCDEFGH@@@@##ZZ##', CHECK_POLICY = OFF;


-- Step 2:(Deny view to any database)
USE master;
GO
DENY VIEW ANY DATABASE TO SushilRout;


 -- Step 3 (Then authorized the user for that specific database , you have to use the  master by doing use master as below)
USE master;
GO
ALTER AUTHORIZATION ON DATABASE::Testing TO SushilRout;
GO

No comments: