Re: Setup login account for application developer to access sql server
From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 10/04/05
- Next message: Andrew J. Kelly: "Re: file/filegroup backup vs copy the mdf, ndf, ldf file directly"
- Previous message: DowningDevelopments: "Re: cannot create a simple table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 03 Oct 2005 20:54:39 -0600
If you want the user to be able to perform any task in just
one database, db_owner would cover it.
You wouldn't want sa - members of sysadmin can perform any
activity on the server, any activity in any database.
-Sue
On Mon, 3 Oct 2005 04:11:01 -0700, Joe
<Joe@discussions.microsoft.com> wrote:
>Dear all,
>If i want to setup login account for application developer to access the
>production sql server
>and i just want the user can preform any task only in one user database (say
>ShoppingCarts)
>what server roles and db roles i need to give to the user?
>Is it i need to give sa server role and then db owner db roles to the db to
>the user
>or i just need to give db owner db roles to the user but no need to give any
>server role to the user?
- Next message: Andrew J. Kelly: "Re: file/filegroup backup vs copy the mdf, ndf, ldf file directly"
- Previous message: DowningDevelopments: "Re: cannot create a simple table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
