Users in database have no associated login

From: Russell White (rwhite04_at_maine.rr.com)
Date: 04/14/04 

Date: Wed, 14 Apr 2004 14:59:29 -0400

we got sql2000 dump from a customer and we can't run against it because, for
some reason, the users in our database don't have associated logins (as seen
in sql enterprise mgr >> db >> users >> login name column). In all other
databases the users of our database have the sa login associated with them.

the users screen in a working db has 3 columns: name (e.g. dbo), Login Name
(e.g sa) and Database Access (e.g. Permit).

in this same screen in the database we can't upgrade/run against the login
name is blank for the dbo user...

any way i can reassociate the sa login w/ this user?

Thanks in advance,

Russ White

Relevant Pages

  • Re: Confused about dbo
    ... neither the explicit database owner or aliased to the dbo user. ... member of the db_owner role does not mean you are aliased to the dbo user. ... When you connect to SQL Server you do so using a login. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... Windows login name. ... login that is the owner of a database and members of the sysadmin role. ... >> the username dbo" ... >> FULL permission to do anything and everything. ...
    (microsoft.public.sqlserver.programming)
  • Re: Change dbo
    ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
    (microsoft.public.sqlserver.security)
  • Re: db_owner role in SQL 2k
    ... The owner of a database is a login, which is listed in the sysdatabases ... I try not to think of DBO as the Database Owner, but just as special, ... For anyone to use any database, their login name must have been given access ...
    (microsoft.public.sqlserver.programming)
  • Re: db_owner role in SQL 2k
    ... > The owner of a database is a login, which is listed in the sysdatabases ... > table in the master database as the owner of the database. ... and their user name will ALWAYS be DBO. ... > automatically members of the public role. ...
    (microsoft.public.sqlserver.programming)