Re: How to hide unauthorized databases with SQL 2005?
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 24 Apr 2006 21:44:20 -0500
VIEW ANY DATABASE is granted to public by default. If you want to remove
this permission from userA:
USE master
DENY VIEW ANY DATABASE TO userA
Although the user still has VIEW ANY DATABASE via public role membership,
the DENY takes precedence.
You could also REVOKE VIEW ANY DATABASE from public and then selectively
grant that permission to users as you see fit.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"SL Coder" <sl_coder@xxxxxxxxxxx> wrote in message
news:e50gEfAaGHA.3704@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
I have configure permission for userA and he can access only one database.
When user estabilish the connection via management studio, though he
cannot access other databases, he can see them. Is it possible to hide
other databases for userA?
Appreciate all your reply.
Shane
.
- Follow-Ups:
- Re: How to hide unauthorized databases with SQL 2005?
- From: SL Coder
- Re: How to hide unauthorized databases with SQL 2005?
- References:
- How to hide unauthorized databases with SQL 2005?
- From: SL Coder
- How to hide unauthorized databases with SQL 2005?
- Prev by Date: Re: Assigning Permissions to a Database
- Next by Date: Re: is there any limit to how long of a string SqlDataReader.GetString() can return?
- Previous by thread: How to hide unauthorized databases with SQL 2005?
- Next by thread: Re: How to hide unauthorized databases with SQL 2005?
- Index(es):
Relevant Pages
|
|
