EnumLoginMappings Method

Database.EnumLoginMappings Method ()

 

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

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public DataTable EnumLoginMappings()

Return Value

Type: System.Data.DataTable

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.

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]
   }
}
Return to top
Show:
© 2016 Microsoft