Steve Bohler
asked on
SQL Server permissions question
We're running SQL Server 2008
I want to create a login and give it access to one database (which I did). But, when this login connects via Management Studio, they can see the names of the other databases. How can I hide even the ability to see what other databases exist?
Thanks in advance.
I want to create a login and give it access to one database (which I did). But, when this login connects via Management Studio, they can see the names of the other databases. How can I hide even the ability to see what other databases exist?
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK, I think I followed the instructions properly.
However, even though the user is the db_owner of the database, when they login, they can see no databases now.
??
However, even though the user is the db_owner of the database, when they login, they can see no databases now.
??
ASKER
OK, I finally got it working.
ASKER
I have a couple of questions.
first, this is a user I've already created. I'm going to delete it.
What is the proper order for creating a user.
Do I first create a Login under Security, then add that user under Users for the database?
How do I "change the Owner" of the database to the new account?