We have an existing SQL Server login that has specific permissions. We would like to keep this login and have a new windows auth login (FRED) have the same permissions as the SQL login (legacy) without having to recreate the windows auth login with all the permissions of the SQL Server login. I have read some about user mapping but I'm not quite sure how this would/could be accomplished with this scenario. Thanks in advance for your help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I map a new Win Auth login to existing SQL login in SQL 2000?
- Thread starter AccountCR
- Start date
Similar threads
- Locked
- Question
- Locked
- Question