Setup login account for application developer to access sql server

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe - 03 Oct 2005 12:11 GMT

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?

Reply to this Message

Sue Hoegemeier - 04 Oct 2005 03:54 GMT

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

>Dear all,
>If i want to setup login account for application developer to access the
[quoted text clipped - 6 lines]
>or i just need to give db owner db roles to the user but no need to give any
>server role to the user?

Reply to this Message