مشاركة عبر


DatabaseMapping Class

The DatabaseMapping object represents a SQL Server database mapping.

Inheritance Hierarchy

System.Object
  Microsoft.SqlServer.Management.Smo.DatabaseMapping

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

Syntax

'Declaration
Public NotInheritable Class DatabaseMapping
'Usage
Dim instance As DatabaseMapping
public sealed class DatabaseMapping
public ref class DatabaseMapping sealed
[<SealedAttribute>]
type DatabaseMapping =  class end
public final class DatabaseMapping

The DatabaseMapping type exposes the following members.

Constructors

  Name Description
Public method DatabaseMapping Initializes a new instance of the DatabaseMapping class for the specified login, database, and user.

Top

Properties

  Name Description
Public property DBName Gets the name of the database in which the login is mapped to the database user.
Public property LoginName Gets the name of the login that is mapped to the user in the database.
Public property UserName Gets the database user that is mapped to the login in the database.

Top

Methods

  Name Description
Public method Equals (Inherited from Object.)
Public method GetHashCode (Inherited from Object.)
Public method GetType (Inherited from Object.)
Public method ToString Returns a string that represents the DatabaseMapping object. (Overrides Object.ToString().)

Top

Remarks

A login allows access to SQL Server, though it does not allocate permissions at a database level. Each login requires mapping to a database user within each database. The information about each mapping is stored in the DatabaseMapping object. Every login has a database mapping for each database that it can access.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Examples

Managing Users, Roles, and Logins

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Principals (Database Engine)