Multiple Login using same user in a DB

From: Philippe Mommens (pmommens@synavant.com)
Date: 10/16/02 

From: "Philippe Mommens" <pmommens@synavant.com>
Date: Wed, 16 Oct 2002 11:30:05 +0200

Hello,

I would like to implement the following:
- Create two login:
       'Server\NT_Group' belong to an NT Group in order to allow trusted
connexion
       'DBUser' that can be used to connect to the DB
with explicit connexion

- I have a database MY_DB
       I would like 1 user to be created ==> 'MY_DBO'

- My wish is that the 2 logins are attached to this user.
   I want the same setting as what is done for the goup
'BUILTIN\Administrators' and the user 'SA' which are granted acces as 'dbo'
in the databases.
   This allow to be connected to the database with the same user when
connecting with trusted or explicit connexion.

In fact once I create the first login and I grant access to the DB, it is
not possible to grant access to another login for the same user.

Does anyone have an idea to solve this?

Thanks in advance,
Philippe

Relevant Pages