Wednesday, 21 December 2016

HOW TO BLOCK USER TO SEE OTHER DATABASE IN SQL SERVER

AS SALAMO ALAIKUM WA RAHMATULLAH

Create Database DemoDB2;
Create Database DemoDB1;

Create User User1;
Create User User2;

use DemoDB2
go
drop user User2;

ALTER AUTHORIZATION ON DATABASE::DemoDB2 TO User2;

user DemoDB2

use master
go


Deny View ANY DATABASE to User2;
--
Passion 4 Oracle
Ma Asalaam

No comments:

Post a Comment