Re: 2 users mapped to 1 login

Yes, it is SQL Server 2005


On Mar 5, 12:32 pm, "Uri Dimant" <u...@xxxxxxxxxxx> wrote:
Is it SQL Server 2005? If it is you can create a user WITHOUT LOGIN take a
look at BOL

"audipen" <audi...@xxxxxxxxx> wrote in message

news:1173077810.060283.38840@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

I have a question regarding logins and users.

Is it possible for 2 users to use the same login to gain access to a
particular database.

Ex: User A and User B use the same login to connect to the server and
then individually access certain tables (maybe different tables) in
the 'Northwind' database.

When I try to add a second user and map it to the same login , I get
an error message - ' The login already has an account under a
different user name.'

Is doing something like this possible OR is there a 1:1 mapping
between a login and a user (for a given database) ?

Thanks
Ady


.

Relevant Pages

  • Re: Limiting a user to only executing a stored only that access an
    ... the underlying source code) and execute a stored procedure. ... I simply gave the user login to the database and ... "What I would like is to create another database, ... Northwind using three part name qualifier. ...
    (microsoft.public.sqlserver.security)
  • Re: Limiting a user to only executing a stored only that access an
    ... the underlying source code) and execute a stored procedure. ... I simply gave the user login to the database and ... "What I would like is to create another database, ... Northwind using three part name qualifier. ...
    (microsoft.public.sqlserver.security)
  • Re: Limiting a user to only executing a stored only that access an
    ... I have a stored procedure on my test database that executes a statement to ... Northwind using three part name qualifier. ... access to the data in db2 without giving him/her a login to that database. ...
    (microsoft.public.sqlserver.security)
  • Re: Limiting a user to only executing a stored only that access an
    ... the underlying source code) and execute a stored procedure. ... I simply gave the user login to the database and ... "What I would like is to create another database, ... Northwind using three part name qualifier. ...
    (microsoft.public.sqlserver.security)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
Quantcast