Login Object

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The Login object exposes the attributes of a single SQL Server Authentication record.

Properties

Database Property	Name Property
DenyNTLogin Property	NTLoginAccessType Property
Language Property	SystemObject Property
LanguageAlias Property	Type Property (Login)

Methods

EnumDatabaseMappings Method	Remove Method (Objects)
GetUserName Method	Script Method
IsMember Method	SetPassword Method
ListMembers Method (Login, User)

解説

Microsoft SQL Server uses two ways to validate connections to SQL Server databases: Windows Authentication and SQL Server Authentication. SQL Server Authentication uses login records to validate the connection. A Login object exposes a SQL Server login record.

With a Login object, you can:

• Create a SQL Server login record for a SQL Server Authentication connection.
• Set the attributes of a SQL Server login record, such as the password or the default database for the login.
• Determine the role membership of a SQL Server login.
• Remove a login record from SQL Server, disabling its use.

  メモ :
  To view, create, or remove SQL Server logins by using the Login object, the connected user must be a member of the SQL Server securityadmin fixed server role.

The Name property of a Login object uses the SQL Server data type sysname. The value of the Name property must be unique for an instance of SQL Server.

A SQL Server login is created with no password and no rights to any database on the server. After successful creation of a SQL Server login, you can use the SetPassword method of the Login object to assign a password to the login. Use the Database User object and the Users collection to grant login access to server resources.

To add a login to a server running SQL Server

1. Create a Login object.

2. Set the Name property.

3. Set the Type property. By default, a login is created for use by SQL Server Authentication. Alternately, specify the login type to map a Windows user or group.

4. Add the Login object to the Logins collection of a connected SQLServer object to create the SQL Server login.

メモ :
The Login object is compatible with instances of SQL Server versions 7.0 and later. However, the Login2 object extends the functionality of the Login object for use with features that were introduced in SQL Server 2000.

参照

関連項目

Login2 Object

その他の技術情報

Notification Services のセキュリティの設定

ヘルプおよび情報

SQL Server 2005 の参考資料の入手