Database.EnumWindowsGroups Database.EnumWindowsGroups Database.EnumWindowsGroups Method

정의

Windows 그룹 목록을 열거합니다. Enumerates a list of Windows groups.

오버로드

EnumWindowsGroups() EnumWindowsGroups() EnumWindowsGroups()

Windows 그룹 목록을 열거합니다. Enumerates a list of Windows groups.

EnumWindowsGroups(String) EnumWindowsGroups(String) EnumWindowsGroups(String)

지정한 그룹에 대한 Windows 그룹 목록을 열거합니다. Enumerates a list of Windows groups for a specified group.

EnumWindowsGroups() EnumWindowsGroups() EnumWindowsGroups()

Windows 그룹 목록을 열거합니다. Enumerates a list of Windows groups.

public:
 System::Data::DataTable ^ EnumWindowsGroups();
public System.Data.DataTable EnumWindowsGroups ();
Public Function EnumWindowsGroups () As DataTable
반환

A DataTable 개체 Windows 그룹의 목록을 포함 하는 값입니다. A DataTable object value that contains a list of Windows groups. 반환 된 다른 열을 설명 하는 테이블 DataTable합니다. The table describes the different columns of the returned DataTable.

Column Data type Description
Urn String The URN string that represents the Windows group.
Name String The name of the Windows group.
ID Int32 The ID value that uniquely identifies the Windows group.
Login String The login that represents the Windows group in SQL Server.
IsSystemObject Boolean The Boolean value that specifies whether the Windows group is a system object.
LoginType DateTime The type of login. See LoginType.
HasDBAccess Boolean The Boolean value that specifies whether the Windows group as access to the referenced database.
Sid Int32 The login security identifier for the Windows group.
UserType String The type of user. See UserType.
Certificate String The certificate that the Windows group uses to log on to SQL Server.
AsymmetricKey String The asymmetric key that the Windows group uses to log on to SQL Server.
CreateDate DateTime The date and time when the Windows group was created.
DateLastModified DateTime The date and time when the Windows group was last modified.
DefaultSchema String The default schema associated with the Windows group.
Column Data type Description
Urn String The URN string that represents the Windows group.
Name String The name of the Windows group.
ID Int32 The ID value that uniquely identifies the Windows group.
Login String The login that represents the Windows group in SQL Server.
IsSystemObject Boolean The Boolean value that specifies whether the Windows group is a system object.
LoginType DateTime The type of login. See LoginType.
HasDBAccess Boolean The Boolean value that specifies whether the Windows group as access to the referenced database.
Sid Int32 The login security identifier for the Windows group.
UserType String The type of user. See UserType.
Certificate String The certificate that the Windows group uses to log on to SQL Server.
AsymmetricKey String The asymmetric key that the Windows group uses to log on to SQL Server.
CreateDate DateTime The date and time when the Windows group was created.
DateLastModified DateTime The date and time when the Windows group was last modified.
DefaultSchema String The default schema associated with the Windows group.

예제

이 예에서는 Server 개체 열거형 메서드를 실행하지만 DataTable 개체에서 정보를 추출하는 것은 데이터베이스 열거형 메서드에 대해 동일합니다.The example runs a Server object enumeration method, but extracting the information from the DataTable object is the same for Database enumeration methods.

VBVB

PowerShellPowerShell

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

$d = new-object System.Data.Datatable  
$d = $srv.EnumCollations  

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

EnumWindowsGroups(String) EnumWindowsGroups(String) EnumWindowsGroups(String)

지정한 그룹에 대한 Windows 그룹 목록을 열거합니다. Enumerates a list of Windows groups for a specified group.

public:
 System::Data::DataTable ^ EnumWindowsGroups(System::String ^ groupName);
public System.Data.DataTable EnumWindowsGroups (string groupName);
Public Function EnumWindowsGroups (groupName As String) As DataTable
매개 변수
groupName
String String String

A String Windows 그룹 이름을 지정 하는 값입니다. A String value that specifies a Windows group name.

반환

지정된 그룹에 대한 Windows 그룹 정보를 포함하는 DataTable 개체 값입니다. A DataTable object value that contains Windows group information for the specified group. 반환 된 다른 열을 설명 하는 테이블 DataTable합니다. The table describes the different columns of the returned DataTable.

Column Data type Description
Urn String The URN string that represents the Windows group.
Name String The name of the Windows group.
ID Int32 The ID value that uniquely identifies the Windows group.
Login String The login that represents the Windows group in SQL Server.
IsSystemObject Boolean The Boolean value that specifies whether the Windows group is a system object.
LoginType DateTime The type of login. See LoginType.
HasDBAccess Boolean The Boolean value that specifies whether the Windows group as access to the referenced database.
Sid Int32 The login security identifier for the Windows group.
UserType String The type of user. See UserType.
Certificate String The certificate that the Windows group uses to log on to SQL Server.
AsymmetricKey String The asymmetric key that the Windows group uses to log on to SQL Server.
CreateDate DateTime The date and time when the Windows group was created.
DateLastModified DateTime The date and time when the Windows group was last modified.
DefaultSchema String The default schema associated with the Windows group.
Column Data type Description
Urn String The URN string that represents the Windows group.
Name String The name of the Windows group.
ID Int32 The ID value that uniquely identifies the Windows group.
Login String The login that represents the Windows group in SQL Server.
IsSystemObject Boolean The Boolean value that specifies whether the Windows group is a system object.
LoginType DateTime The type of login. See LoginType.
HasDBAccess Boolean The Boolean value that specifies whether the Windows group as access to the referenced database.
Sid Int32 The login security identifier for the Windows group.
UserType String The type of user. See UserType.
Certificate String The certificate that the Windows group uses to log on to SQL Server.
AsymmetricKey String The asymmetric key that the Windows group uses to log on to SQL Server.
CreateDate DateTime The date and time when the Windows group was created.
DateLastModified DateTime The date and time when the Windows group was last modified.
DefaultSchema String The default schema associated with the Windows group.

예제

이 예에서는 Server 개체 열거형 메서드를 실행하지만 DataTable 개체에서 정보를 추출하는 것은 데이터베이스 열거형 메서드에 대해 동일합니다.The example runs a Server object enumeration method, but extracting the information from the DataTable object is the same for Database enumeration methods.

VBVB

PowerShellPowerShell

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

$d = new-object System.Data.Datatable  
$d = $srv.EnumCollations  

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

적용 대상