Re: How to hide unauthorized databases with SQL 2005?
- From: "SL Coder" <sl_coder@xxxxxxxxxxx>
- Date: Tue, 25 Apr 2006 09:49:09 +0600
Thanks for the reply Dan. But the problem is, this statement applies for all databases that is not what I want. I need to allow userA to see one database while denying other databases. Is it possible. Have I missed anything?
Shane
"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:%2300soIBaGHA.3304@xxxxxxxxxxxxxxxxxxxxxxx
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: Dan Guzman
- Re: How to hide unauthorized databases with SQL 2005?
- References:
- How to hide unauthorized databases with SQL 2005?
- From: SL Coder
- Re: How to hide unauthorized databases with SQL 2005?
- From: Dan Guzman
- How to hide unauthorized databases with SQL 2005?
- Prev by Date: Re: is there any limit to how long of a string SqlDataReader.GetString() can return?
- Next by Date: Re: public role question
- Previous by thread: Re: How to hide unauthorized databases with SQL 2005?
- Next by thread: Re: How to hide unauthorized databases with SQL 2005?
- Index(es):
Relevant Pages
|
