February 13, 2008 at 9:30 am
Hello
I have a team of SQL developers who need permission to execute test queries and store procedures.
Is there a way i can map the team's windows username account's into a group, and give that group the neccessary permissions?
Also, I want to develop a long term solution; of which there been an “automated” approach/solution to the problem of the DB's rename causing permission problems for users in the SQLDeveloper role?
February 13, 2008 at 9:58 am
Sure. Add the Windows logins to a Windows group, add the group as a login in SQL Server, grant the login access to the databases that need testing, and grant EXECUTE permission on stored procedures. If they also need to run custom queries, grant the group membership in the db_datareader fixed database role.
As for your second question, are saying that the logins lose permission to a database when it's renamed?
Greg
February 13, 2008 at 10:52 am
Yeah, thats the answer to my second question, permission are affected when a database name is renamed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply