| Author |
Topic |
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
 Posted - 2010-08-31 : 15:25:43
|
| Hi,We have a situation where we have an application that can be used by both users in active directory in orgaization and outisde users that are not in Ad but in a users table of application. I was thinking of creating the security for these none AD users but thought of leveraging SQL's security. Is it possible to assign,add non AD users to certain SQL groups? How best to approach this? Should I just create a SQL proxy user and then map these users via this proxy account?Thanks!If you don't have the passion to help people, you have no passion |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-08-31 : 15:37:37
|
| Almighty Tara,I shall try that. The thing is these users will not have a windows account. They are remote users coming in via our public website.I want to have one security scheme for internal users with windows account and another one for external users.will that mean I also have to add windows account into this security table?Merci!!If you don't have the passion to help people, you have no passion |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-08-31 : 16:32:37
|
| thanks! so does that mean I will need some kind of extraction job running to tap into active directory/ldap and populate the security table? will this also mean the internal users will have to have another user name/password? I was hoping that this security table would be using nt authentication for internal users so that they can use their domain user name password and external users use user name password from security table.Or we might just add the external users in our domain and go all windows authentication. This approach I am attempting seems to involve some level of effort. Thanks!!If you don't have the passion to help people, you have no passion |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2010-08-31 : 16:54:08
|
| ok so you are saying the security table is strictly for external users? ok so this is what I will have the UI folks do. Create a hybrid authentication windows form asp.net allows for that I believe. Have only external users in security table... UI by default will have internal user checkbox ticked (default with remember my settings etc). It will do windows authentication otherwise do security table authentication. Have 2 virtual directories for internal and external with one common welcome page. Something like that Thanks!!!If you don't have the passion to help people, you have no passion |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
security design for non AD users