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

Windows users mapped to SQL Groups Expand / Collapse
Author
Message
Posted Thursday, April 16, 2009 7:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:55 AM
Points: 184, Visits: 855
In my Sql Server 2005 I have few groups (eg:SQLAdministrator) that have sysadmin privilege. I need to find out the windows users that are mapped to these groups. Also I need to find out the date when these users were mapped to the groups.

I am looking for some kind of script that can give me this information.

Thanx in Advance !


Sanz
Post #698368
Posted Thursday, April 16, 2009 7:07 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
This should give you a good starting point

http://cwashington.netreach.net/depo/view.asp?Index=1119
Post #698378
Posted Thursday, April 16, 2009 7:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:55 AM
Points: 184, Visits: 855
Thanx for the quick response.

I was looking for a way to query if from Sql Server.


Sanz
Post #698384
Posted Thursday, April 16, 2009 7:18 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
I think you will need a linked connection setup

http://www.sqlservercentral.com/Forums/Topic695128-359-1.aspx
Post #698390
Posted Thursday, April 16, 2009 7:36 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, October 17, 2014 3:55 AM
Points: 184, Visits: 855
Is there any system table/tables that contain this information ??

Sanz
Post #698414
Posted Thursday, April 16, 2009 7:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 2:58 PM
Points: 1,141, Visits: 944
Not by default. Although, based on your requirements it would be possible to script something to pull this information periodically in a database.
Post #698427
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse