Re: question about syslogins and sysusers...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: ===steve pdx=== (lins_at_nospam_portptld.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 11:26:11 -0700

I appreciate the responses i've got, but I'd like to make my question more
clear:

there are accounts found in sysusers table(s), but not in syslogins in
master database. Not the other way around!
(which is ok, an account can be in syslogins but not necessary has to be in
any sysusers table)

also, what's the difference between isntname and isntuser? why for some
accouts, the values are different? e.g. isntname = 1 but isntuser =0

thank you.

"===steve pdx===" <lins@nospam_portptld.com> wrote in message
news:eSjJG3ifEHA.1972@TK2MSFTNGP09.phx.gbl...
> background: sql2k on nt5.
>
> there is a view in master database, and a sysusers table in each database.
> if an account is found in sysusers table, but not in syslogins table, what
> does that mean?
> how did that happen,
> and how to clean it up or sync up?
>
> thank you.
>
>

Relevant Pages

  • Re: question about syslogins and sysusers...
    ... Does the sid number in sysusers exist in syslogins. ... >> Windows group, and a member of that group creates an object in a database, ... >> Suppose you have a Windows account 'MyDomain\Fred' in a group ...
    (microsoft.public.sqlserver.programming)
  • Re: question about syslogins and sysusers...
    ... > Windows group, and a member of that group creates an object in a database, ... > Suppose you have a Windows account 'MyDomain\Fred' in a group ... > will create an entry in syslogins) and add the group to the DDLAdmin role ... > Northwind databases sysusers table). ...
    (microsoft.public.sqlserver.programming)
  • RE: Not able to make table design changes
    ... I did go through the orphan user initially but still have this problem. ... If I completely remove the user from the sysusers table it still comes up with: ... Removed the account from the sysxlogins table in master database and user database. ...
    (microsoft.public.sqlserver.security)
  • question about syslogins and sysusers...
    ... background: sql2k on nt5. ... there is a view in master database, and a sysusers table in each database. ... if an account is found in sysusers table, but not in syslogins table, what ...
    (microsoft.public.sqlserver.programming)
  • RE: Sysusers Table
    ... Syslogins and sysusers are not involved in licensing at all. ... more users than the number of CALs, as long as only 5 users access ...
    (microsoft.public.sqlserver.server)