Re: Allow users to only see their mapped DBs
- From: Ekrem Önsoy <ekrem@xxxxxxxxxxxx>
- Date: Sat, 21 Jun 2008 12:54:31 +0300
Erland,
Do you think MS developers will do something about this matter in SQL Server 2008?
I also get this kind of questions from our local newsgroups and I also say "it's not possible -at least for this version of SQL Server".
As far as I know, there were some feedbacks about this issue and people were voting for it. However I don't know if MS has taken an action or not. If there's an improvement about it in SS2008, I believe you must be know about it.
--
Ekrem Önsoy
"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message news:Xns9AC481961FCAYazorman@xxxxxxxxxxxx
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: Erland Sommarskog
- Re: Allow users to only see their mapped DBs
- References:
- Allow users to only see their mapped DBs
- From: Rob
- Re: Allow users to only see their mapped DBs
- From: Erland Sommarskog
- Allow users to only see their mapped DBs
- Prev by Date: Re: Grant v Deny
- Next by Date: Re: Allow users to only see their mapped DBs
- Previous by thread: Re: Allow users to only see their mapped DBs
- Next by thread: Re: Allow users to only see their mapped DBs
- Index(es):
Relevant Pages
|
