Database.EnumLoginMappings Database.EnumLoginMappings Database.EnumLoginMappings Method

Definition

Enumerates a list of SQL Server logins for all the users in the database.

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

A DataTable object value that contains a list of logon mappings to users in the database. The table describes the different columns of the returned DataTable.

Column
Data type
Description.
UserName
String The name of the database user.
LoginName
String The login account that is mapped to the database user in the referenced database.

Examples

The example runs a server object enumeration method, but extracting the information from the datatable object is the same for database enumeration methods.

VB

PowerShell

$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]  
   }  
}  

Applies to