FAQ: How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

case when pl sql

case when pl sql — Sat, 12 Jul 2008 02:07:29 GMT

PingBack from http://darren.onlineshoppingvidsworld.info/casewhenplsql.html

re: FAQ: How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

kevin.bailey — Wed, 06 Dec 2006 22:41:38 GMT

The way around getting foo to show up after the deny view any database to login2 is:

1) log in as sa and delete the database foo.

2) while logged in as sa, grant user login2 create database permission.

3) Grant all permissions to master and tempdb to user login2.

4) log out of sa.

5) log in as login2 user.

6) create table foo while logged in as login2 and set login2 as table owner.

Now foo will show up as the only database, except master and tempdb (which you want anyway).

re: FAQ: How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

Darshan Singh — Thu, 15 Jun 2006 23:09:19 GMT

SQL Server 9.0.2047

The database 'foo' shows up for login2 when execution context is changed using EXECUTE AS. However, if you login to Query Window or Object Explorer using login2, the database 'foo' does not show up.

After granting VIEW DEFINITION to user2, if you connect to Query Window or Object Explorer using login2, database foo does not show up.

When connected to query window using login2, initially the database foo does not show up in Available Databases list. But "use foo" works, and database then shows up in Available Databases combo on top. And then sys.databases returns 'foo'.

TIP - How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

SQL, .NET and everything Microsoft — Sun, 28 May 2006 07:24:04 GMT

I came across this excellent blog by Euan Garden, who is a Group Program Manager at Microsoft.
http://blogs.msdn.com/euanga/archive/2006/05/04/585513.aspx...

Euan Garden - FAQ: How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

Professional Association for SQL Server (PASS) SIG — Wed, 10 May 2006 21:49:18 GMT

re: FAQ: How do I prevent users from seeing DBs in Enterprise Manager/SSMS that they don't have rights to?

Sivashankar — Fri, 05 May 2006 11:46:34 GMT

Its realy a fantastic work....!!!!!!!