Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eltontodd
Starting Member
3 Posts |
 Posted - 2008-11-10 : 14:37:51
|
| 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. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 15:07:36
|
| No you can't. |
 |
|
|
eltontodd
Starting Member
3 Posts |
Posted - 2008-11-10 : 15:26:02
|
| So there is no way to have a new login imitate an existing login's security credentials? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 16:05:50
|
| Each login has Security identifier(SID).You can imitate existing login's permission not credentials for newly created Login. |
|
|
|
eltontodd
Starting Member
3 Posts |
Posted - 2008-11-10 : 16:09:53
|
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? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 17:16:47
|
| Check sp_helplogins 'Loginname',syslogins and sp_helpprotect for object level permissions. |
|
|
|
|
|
|
Can I map Win Auth login to SQL login in SQL 2000?