SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Can I map Win Auth login to SQL login in SQL 2000?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

eltontodd
Starting Member

3 Posts

Posted - 11/10/2008 :  14:37:51  Show Profile  Reply with Quote
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.

Edited by - eltontodd on 11/10/2008 14:54:28

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 11/10/2008 :  15:07:36  Show Profile  Reply with Quote
No you can't.
Go to Top of Page

eltontodd
Starting Member

3 Posts

Posted - 11/10/2008 :  15:26:02  Show Profile  Reply with Quote
So there is no way to have a new login imitate an existing login's security credentials?
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 11/10/2008 :  16:05:50  Show Profile  Reply with Quote
Each login has Security identifier(SID).You can imitate existing login's permission not credentials for newly created Login.
Go to Top of Page

eltontodd
Starting Member

3 Posts

Posted - 11/10/2008 :  16:09:53  Show Profile  Reply with Quote
quote:
Originally posted by sodeep

Each login has Security identifier(SID).You can imitate existing login's permission not credentials for newly created Login.



What would be the best way to imitate a login's permissions?
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 11/10/2008 :  17:16:47  Show Profile  Reply with Quote
Check sp_helplogins 'Loginname',syslogins and sp_helpprotect for object level permissions.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000