Re: Allow users to only see their mapped DBs
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 20 Jun 2008 15:47:34 -0700
Rob (Rob@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
How can I can allow my users to only see the DBs their user ID has been
mapped to when they open up SSMS? When they open up SSMS today, they can
see all the DBs; I want to restrict their view to only the DBs that
their ID is mapped to.
That is not possible. You can revoke the VIEW ANY DATABASE permission,
but then users will only be able to see databases they own.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Allow users to only see their mapped DBs
- From: Ekrem Önsoy
- Re: Allow users to only see their mapped DBs
- References:
- Allow users to only see their mapped DBs
- From: Rob
- Allow users to only see their mapped DBs
- Prev by Date: Re: Grant v Deny
- Next by Date: Re: Grant v Deny
- Previous by thread: Allow users to only see their mapped DBs
- Next by thread: Re: Allow users to only see their mapped DBs
- Index(es):
Relevant Pages
|
