Mapping Windows usernames to SQL login

  • 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

  • Yeah, thats the answer to my second question, permission are affected when a database name is renamed.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply