Single login, multiple passwords

From: sqldummy (sqldummy_at_discussions.microsoft.com)
Date: 05/31/05 

Date: Tue, 31 May 2005 05:37:14 -0700

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

Relevant Pages

  • Re: Why save SSIS using integrated security
    ... Mostly MS are recommending integrated security over SQL Authentication - not ... and the restrictions that come with Windows passwords can ... working accross domains, unix clients, working over the internet etc. ...
    (microsoft.public.sqlserver.dts)
  • Expire passwords
    ... Is there a way to enforce the users to change their passwords every 90 days ... to delete a login if the user has not login X number of days? ... I am using Windows 2000/ SQL Server 2000/ SQL authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: one user, multiple passwords?
    ... It is no possible to have 2 passwords for a single login. ... > Is it possible to have one user with a single user name accessing two ... different databases in the same server instance, ...
    (microsoft.public.sqlserver.server)