How to link a login to a database user

  • Thread starter Thread starter Krygim
  • Start date Start date
K

Krygim

USER1 is the db_owner of the database INVENTORY. There exists an identical
SQL Server login name USER1. When I double-click on the login name, in the
Database Access page, I find that USER1 is permitted to access INVENTORY.
However, there is no linkage between the login USER1 and database owner
USER1. The "User" cell at the right of the INVENTORY database is blank in
the Database Access page. However when I try to enter USER1 into the cell, I
get an error message telling me the user USER1 already exists in INVENTORY.




However can I link the login name to the database user name?




TIA
 
Hi,

Fireup Enterprise Manager - SQL-EM.

If when adding a New User into the Logons (Security branch) you click the
Inventory database you find that you get the error message (yip that is what
you complain about), then cancel out, open up the Inventory DB, open up
users, and delete User1. Then repeat this process making sure you tick
Inventory database when adding the user back in.

- Tim
 
Hi Tim,

Thanks for your solution. However doing that will lose all the permission
settings of USER1 in INVENTORY. Will there be a way to keep the settings?

KM
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MSAccess on windows Vista 2
Creating a Multi-User Login 3
Moving BCM 2007 Database to a SQL 2005 Server 2
Access User Login form in Access with Ristriction 0
asp.net and conecting to sql server2005 2
How can I force a re-login to another win2k system's share 6
The user has not been granted the requested logon type. 2
Windows XP login Error 3

Back
Top