|
Home > Archive > MS SQL Server security > May 2005 > Single login, multiple passwords
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Single login, multiple passwords
|
|
| sqldummy 2005-05-31, 7:23 am |
| Is it at all possible to have a single login have multiple passwords?
We are using sql authentication.
We run multiple applications with different db's. For each appl, a
administrator can add users and assign passwords. If the login already
exists, the admin. wants to add the user with a newly specified password, but
it shoud still allow the passwords assigned previously. The only way I can
think of, is to use a single login to log onto the server, and then verify
user credentials programmatically against the database. Is there a way that
SQL Server can handle this??
Please help.
Thanks
| |
| Hari Prasad 2005-05-31, 8:23 pm |
| Hi,
We can have only one password for 1 user. I recommend you have different
logins and users.
Other alternative is handle the application authentication by creating a new
table for application users.
Thanks
Hari
SQL Server MVP
"sqldummy" < sqldummy@discussions
.microsoft.com> wrote in message
news:679BDF12-C715-42F4-95DE- A26310FE0C1B@microso
ft.com...
> Is it at all possible to have a single login have multiple passwords?
> We are using sql authentication.
> We run multiple applications with different db's. For each appl, a
> administrator can add users and assign passwords. If the login already
> exists, the admin. wants to add the user with a newly specified password,
> but
> it shoud still allow the passwords assigned previously. The only way I
> can
> think of, is to use a single login to log onto the server, and then verify
> user credentials programmatically against the database. Is there a way
> that
> SQL Server can handle this??
> Please help.
> Thanks
|
|
|
|
|