patternsqlMinor
hide system databases sql server management studio
Viewed 0 times
databasessqlsystemmanagementstudioserverhide
Problem
I have installed sql server express 2008 and also sql server management studio. I've successfully configured remote connectivity and created a database user and password.
my problem is that in the remote sql server management studio - i want the user to only see the database i assign to them and not see System Databases
I've noticed that the sa login also appears in the folder tree in my remote session which i do not want
How do I go about hiding the system databases as well as logins so that the remote connection only sees logins and database relevant to them
my problem is that in the remote sql server management studio - i want the user to only see the database i assign to them and not see System Databases
I've noticed that the sa login also appears in the folder tree in my remote session which i do not want
How do I go about hiding the system databases as well as logins so that the remote connection only sees logins and database relevant to them
Solution
You can hide the system database in SQL Management Studio following Way that I have mentioned below.
Navigate Tools-->Options-->Environment-->General and choose "Hide
system objects in Object Explorer".
OR
In the SQL Server Management Studio, Right click the server and click
"Properties". Click on "Permissions" and then select the "Public" role
and remove "Grant" from "View Any Database".
Or You can use
Navigate Tools-->Options-->Environment-->General and choose "Hide
system objects in Object Explorer".
OR
In the SQL Server Management Studio, Right click the server and click
"Properties". Click on "Permissions" and then select the "Public" role
and remove "Grant" from "View Any Database".
Or You can use
USE
ALTER AUTHORIZATION ON DATABASE:: to
USE MASTER
DENY VIEW ANY DATABASE TO Code Snippets
USE <YourDatabase>
ALTER AUTHORIZATION ON DATABASE::<YourDatabase> to <Login>
USE MASTER
DENY VIEW ANY DATABASE TO <Login>Context
StackExchange Database Administrators Q#85868, answer score: 3
Revisions (0)
No revisions yet.