Deny View Any Database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Deny View Any Database

Author

Topic

jbosco1988
Starting Member

46 Posts

Posted - 2012-09-24 : 16:46:36

Hello,

IN SQL 2008/2012 is there any way to make so a user only can see the databases that they have access to.

I have tried the following

Deny View any Database to Public
Deny View any Database to User

When I do the above all I see is the Master and Tempdb.

How do I change so the user can see the database they have access to.

Thanks,

Jim

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2012-09-25 : 04:09:38

Unfortunatly NO.
Read this... http://connectsql.blogspot.com/2010/12/sql-server-hide-database-name-in-ssms.html

--------------------------
http://connectsql.blogspot.com/

jbosco1988
Starting Member

46 Posts

Posted - 2012-09-25 : 16:32:18

Ok thanks for the reply.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources