Re: contents of the sysusers table

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/21/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Thu, 20 Jun 2002 17:50:15 -0600

You could have orphaned users or you could be seeing
something related to object access vs. database accessTo
check for orphans, run sp_change_users_login. Details are in
books online.
When you look at sysusers, you should also look at
hasdbaccess. An entry in sysusers doesn't mean the person
has access to the database. Entries in sysusers aren't
determined only by the user but also by who created created
objects in the database. The following link to Chapter 7 of
SQL Server 2000 Administrators Companion has a section
called Database Access vs. Object Access which explains some
of this (watch out for line wrap on the link):
http://www.microsoft.com/technet/prodtechnol/sql/proddocs/admincmp/75517c07.asp
You may want to also check the following link as it has info
on the security system tables, what's populated/updated for
what, etc:
SQL Server 2000 Security
http://www.microsoft.com/technet/prodtechnol/sql/maintain/security/sql2ksec.asp

-Sue

On Wed, 19 Jun 2002 12:55:29 -0700, "juanita"
<jdrobish@lafayettegov.com> wrote:

>HI. I'm confused on what goes in the SYSUSERS table. I
>have my sysusers table for a database that contains
>individual user names but those names are not defined as
>logins to the server or as users under the particular
>database. Those names are part of the NT group THAT IS a
>login to the server and IS a user to the particular
>database. How does the sysusers table get individual user
>names..
>
>Thanks
>juanita

Relevant Pages

  • Re: Error 21002: [ SQL-DMO] User "xxxxx" already exists.
    ... Can you check in the sysusers table of the respective database to see if ... the name SQL Server thinks exists is in there? ... --- Microsoft Outlook Express 6.00.2800.1123 ...
    (microsoft.public.sqlserver.security)
  • every user to take his id
    ... I have sql server 2005 database. ... id from sysusers and the date of insert. ... haven't permissions for this table. ...
    (microsoft.public.sqlserver)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
Quantcast