Server.EnumWindowsGroupInfo Server.EnumWindowsGroupInfo Server.EnumWindowsGroupInfo Method

Definition

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

Overloads

EnumWindowsGroupInfo() EnumWindowsGroupInfo() EnumWindowsGroupInfo()

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

EnumWindowsGroupInfo(String) EnumWindowsGroupInfo(String) EnumWindowsGroupInfo(String)

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

EnumWindowsGroupInfo(String, Boolean) EnumWindowsGroupInfo(String, Boolean) EnumWindowsGroupInfo(String, Boolean)

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server and with the option to list the individual members.

EnumWindowsGroupInfo() EnumWindowsGroupInfo() EnumWindowsGroupInfo()

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

public:
 System::Data::DataTable ^ EnumWindowsGroupInfo();
public System.Data.DataTable EnumWindowsGroupInfo ();
Public Function EnumWindowsGroupInfo () As DataTable
Returns

A DataTable system object value that contains a list of Windows groups that have explicitly granted access to the instance of SQL Server. The table describes the different columns of the returned DataTable.

Column
Data type
Description
account name
String The name of the Windows NT user. NT AUTHORITY\SYSTEM, for example.
type
String The type of user. This specifies whether the user is an individual account or a group account.
privilege
String The privilege level assigned to the Windows NT group.
mapped login name
String The SQL Server login account to which the Windows NT group is mapped.
permission path
String The permission path for the Windows NT group.

Examples

C#

Server srv = new Server("(local)");  

DataTable d = srv.EnumWindowsGroupInfo();  
foreach (DataRow r in d.Rows)  
{  
   Console.WriteLine("============================================");  
   foreach(DataColumn c in d.Columns)  
   {  
      Console.WriteLine(c.ColumnName + " = " + r[c].ToString());  
   }  
}  

PowerShell

$srv = new-Object Microsoft.SqlServer.Management.Smo.Server("(local)")  

$d = $srv.EnumWindowsGroupInfo()  
foreach ($r in $d.Rows)  
{  
   Write-Host "============================================"  
   Foreach ($c in $d.Columns)  
   {  
      Write-Host $c.ColumnName "=" $r[$c]  
   }  
}  

EnumWindowsGroupInfo(String) EnumWindowsGroupInfo(String) EnumWindowsGroupInfo(String)

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server.

public:
 System::Data::DataTable ^ EnumWindowsGroupInfo(System::String ^ group);
public System.Data.DataTable EnumWindowsGroupInfo (string group);
Public Function EnumWindowsGroupInfo (group As String) As DataTable
Parameters
group
String String String

A String value that specifies a Windows group on which to limit the results.

Returns

A DataTable system object value that contains a list of Windows groups that have explicitly granted access to the instance of SQL Server. The table describes the different columns of the returned DataTable.

Column
Data type
Description
account name
String The name of the Windows NT user. NT AUTHORITY\SYSTEM, for example.
type
String The type of user. This specifies whether the user is an individual account or a group account.
privilege
String The privilege level assigned to the Windows NT group.
mapped login name
String The SQL Server login account to which the Windows NT group is mapped.
permission path
String The permission path for the Windows NT group.

EnumWindowsGroupInfo(String, Boolean) EnumWindowsGroupInfo(String, Boolean) EnumWindowsGroupInfo(String, Boolean)

Enumerates a list of information about all Microsoft Windows groups that have explicitly granted access to the instance of SQL Server and with the option to list the individual members.

public:
 System::Data::DataTable ^ EnumWindowsGroupInfo(System::String ^ group, bool listMembers);
public System.Data.DataTable EnumWindowsGroupInfo (string group, bool listMembers);
Public Function EnumWindowsGroupInfo (group As String, listMembers As Boolean) As DataTable
Parameters
group
String String String

A String value that specifies a Windows group on which to limit the results.

listMembers
Boolean Boolean Boolean

A Boolean value that specifies whether to list the members of the Windows group that has been granted access to the instance of SQL Server.

If True, the individual members are listed.

If False, the individual members are not listed.

Returns

A DataTable system object value that contains a list of Windows groups that have explicitly granted access to the instance of SQL Server. The table describes the different columns of the returned DataTable.

Column
Data type
Description
account name
String The name of the Windows NT user. NT AUTHORITY\SYSTEM, for example.
type
String The type of user. This specifies whether the user is an individual account or a group account.
privilege
String The privilege level assigned to the Windows NT group.
mapped login name
String The SQL Server login account to which the Windows NT group is mapped.
permission path
String The permission path for the Windows NT group.

Applies to