December 21, 2004 at 6:35 pm
Is there a SQL xp_ or sp_ to return all database user names different then sp_helpuser?
What xp_ other then logininfo could be used to retun info?
What I need is to return all login names with the server role they belong to, all database user names with their groups and the database they are in...
The problem I'm having is the I need this info on the server level - for example:
If USER1 in DB1 belong to ROLE1 and in the same time he is a part of System Aamin server role I need top see that. The part of the problem is that I have the same user in different database and he has different groups in each of them. I need to define by the combination if this user will be checked or not... I kind of found the way for the SQL logins but not for the integrated security.
Thanks a lot.
MJ
December 22, 2004 at 8:26 am
In order to get this information, your going to have to put a script together because there aren't any already provided system stored procedures.
Sysusers in each database ties to syslogins in master via the SID column in both tables. The syslogins table has columns for the various server roles.
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply