Re: HELP !! Restrict db_owner from changing database properties.

From: Kami Marks [MSFT] (sqldev@microsoft.com)
Date: 12/04/02 

From: "Kami Marks [MSFT]" <sqldev@microsoft.com>
Date: Wed, 4 Dec 2002 10:31:28 -0800

Shrenik-

What is it you want the user to have access to? Do you only want them to be
able to view the database properties? If so, you won't want to give them
db_owner role membership, as that would grant more permissions than you
need.

Please be more specific in what you would like the user to have access to.

Thanks.

Kami Marks/Diane Margheim 

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Shrenik" <shrenik.s@directi.com> wrote in message
news:1ee4d01c29794$246f67b0$89f82ecf@TK2MSFTNGXA01...
> hi,
>
> please help me to find a way out here in security web of
> MS SQL Server 2000.
>
> I am trying to create a new database on server, trying to
> create a new user login for the same with db_owner Role
> membership, and i want that user to access the database
> properties but don't want to allow him to change the
> database properties.
>
> I have seen such existing configuration on SQL Server 7.0
> and want to implement the same on 2000. Can anybody of
> you please help me to set the appropriate permissions
> regardig the same.
>
> thanks in advance.
> Shrenik.

Relevant Pages
Quantcast