Re: EM does not display Login Name
From: Simon (Simon_at_discussions.microsoft.com)
Date: Mon, 28 Feb 2005 14:53:03 -0800
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"
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
"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
> 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
> you get NULL in the Login column.
> Suggestion: Use a script with 'sp_dropuser' resp. 'sp_revokedbaccess' and 'grantdbaccess' to delete and rebuild the
> If the DB owner user dbo is also void, use 'sp_changedbowner' to reassign it.