Re: EM does not display Login Name

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 03/01/05

  • Next message: Jason Williard: "Duplicate Domains Listed - Unable to Add Logins" 
    Date: Mon, 28 Feb 2005 21:25:29 -0700

    You can have null for the login name where there isn't a
    matching record in the syslogins table in the master
    database. The syslogins table and the sysusers table will be
    joined on sid. If no matching record is found in syslogins
    by sid, then the login name is null and nothing will display
    for Login Name in Enterprise Manager.

    -Sue

    On Mon, 28 Feb 2005 14:53:03 -0800, "Simon"
    <Simon@discussions.microsoft.com> wrote:

    >Hi Joachim,
    >
    >Yes, sp_helpuser does return null. However, we are using a script with the
    >mentioned sp's to add users to this database. Way the app works is by a user
    >entering details passed through to the script (sp). Some work, some don't.
    >
    >We have two machines (Prod & Test) and the results can differ. UserA might
    >be fine on Prod but not on Test, UserB might befine on Test but not on Prod.
    >
    >Repeatedly dropping and adding the user gets consistent results on each
    >machine, whether that be by script, Query Analyser, Enterprise Manager. I
    >can spot no common denominator, and have found no way to make a "nulling"
    >user not-null.
    >
    >Only other thing that I can think worth mentioning: at the Security | Logins
    >level we have added "Domain\All Users" to grant all users server access.
    >Database access is granted on a user by user basis (via the script mentioned
    >earlier.)
    >
    >Simon.
    >
    >
    >"Joachim Hofmann" wrote:
    >
    >> Simon wrote:
    >>
    >> > Name Login Name Database Access
    >> > ------------------------------------------------
    >> > User1 Domain\U1 Permit
    >> > User2 Permit
    >> > User3 Domain\U3 Permit
    >> > ^- no login name for Domain\U2
    >>
    >> Simon,
    >>
    >> we are encountering the same effect, when I do a RESTORE from a Database Backup
    >> from a Server which is not in the Windows Domain. I suppose it has something to
    >> do with an orphaned User SID.
    >> I suppose when you enter
    >>
    >> use mydb
    >> sp_helpuser
    >>
    >> you get NULL in the Login column.
    >>
    >> Suggestion: Use a script with 'sp_dropuser' resp. 'sp_revokedbaccess' and 'grantdbaccess' to delete and rebuild the
    >> user(s).
    >> If the DB owner user dbo is also void, use 'sp_changedbowner' to reassign it.
    >>
    >>
    >> Joachim
    >>

  • Next message: Jason Williard: "Duplicate Domains Listed - Unable to Add Logins"

    Relevant Pages

    • Abusing poor programming techniques in webserver scripts V 1.0
      ... $login = Request.Form ... fool the database parser. ... verified in the script of access to the database, ... The SQL statement will be parsed by the database manager, ...
      (SecProg)
    • Permission issue with EXECUTE AS
      ... I've included my script at the end. ... DROP DATABASE BulkCopyTest; ... DROP LOGIN BulkUser; ... DROP LOGIN BulkAccount; ...
      (microsoft.public.sqlserver.security)
    • I missed one "little" thing - Thanks!!!!
      ... I had done everything your script does through EM. ... Added ASPNET as a login with no server roles but database access to ...
      (microsoft.public.sqlserver.security)
    • RE: Working on a log in script to my webpage
      ... regarding the issue of creating a login script... ... > I have the username and the password stored in a PostgreSQL database. ... > If the codes from the loginpage matches the users codes in the db ...
      (comp.lang.python)
    • 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)