-- 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
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:
Post a Comment