Tuesday, March 27, 2012

basic question on permissions..

I have some contractors termserving into my sql2000
server. They need to admin the sql databases and use the
query analyzer. What is the best way for me to give them
permissions to do this without making them local
administrators of the box?Can you allow them to Term Serv into another machine other than SQL?
Running queries and managing the database doesn't equate to having to be a
sysadmin.
What exactly do they need to do?
Perhaps all they need is DBO access to their database, not Sysadmin access
to the entire server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

No comments:

Post a Comment