Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

sp_helplogins 'domain\account' Results Doesn't Match Management Studio Results Expand / Collapse
Author
Message
Posted Thursday, January 6, 2011 12:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 27, 2012 2:34 PM
Points: 43, Visits: 735
Howdy,

Any help is appreciated.

I've discovered that for some login IDs when I view the databases and permissions for a domain account in Management Studio >> Security >> Logins, it looks like this account is not setup in any databases.

When I run sp_helplogins for that same ID I get a list of databases and roles.

I've run sp_change_users_login 'Auto_Fix' for the ID for a database listed in the sp_helplogins results and receive ...

The number of orphaned users fixed by updating users was 0.
The number of orphaned users fixed by adding new logins and then updating users was 0.

... and what's displayed in Management Studio >> Security >> Logins remains unchanged.

What can I do to correct the GUI display in Management Studio >> Security >> Logins?

...thanks
Post #1043982
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse