次の方法で共有


DatabaseRole Object

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

The DatabaseRole object represents the properties of a single Microsoft SQL Server database role.

現在のオブジェクトを表す SQL-DMO オブジェクト モデル

Properties

AppRole Property

Password Property

Name Property

 

Methods

AddMember Method

ListDatabasePermissions Method

DropMember Method

ListObjectPermissions Method

EnumDatabaseRoleMember Method

Remove Method (Objects)

EnumFixedDatabaseRolePermission Method

Script Method

IsFixedRole Method

 

解説

SQL Server database roles establish groups of users with similar security attributes. Database permissions can be granted by role, simplifying database security planning and administration. With the DatabaseRole object, you can:

  • Create a SQL Server database role.
  • Administer an existing SQL Server database role by adding or dropping role members.

The Name property of a DatabaseRole object uses the SQL Server data type sysname.

To create a SQL Server database role

  1. Create a DatabaseRole object.

  2. Set the Name property.

  3. If creating a SQL Server application role, set the AppRole property to TRUE. Set the Password property on the application role (optional).

  4. Add the DatabaseRole object to the DatabaseRoles collection of a connected Database object.

  5. Add members to the DatabaseRole. Members can be drawn from the Name property of User objects in the Users collection of the Database object.

After creating the new SQL Server database role, you can use the Grant and Deny methods of the Database, StoredProcedure, Table, and View objects to set permissions for the new SQL Server database role.

To administer an existing SQL Server database role

  1. Get the DatabaseRole object that references the SQL Server database role from the DatabaseRoles collection of a connected SQLServer Database object.

  2. Use the AddMember or DropMember method to add or remove a specified user. SQL Distributed Management Objects (SQL-DMO) applies the changes to the SQL Server database role as you make them.

ms131505.note(ja-jp,SQL.90).gifメモ :
The DatabaseRole object is compatible with instances of SQL Server version 7.0 and later. However, the DatabaseRole2 object extends the functionality of the DatabaseRole object for use with features that were introduced in SQL Server 2000.

参照

関連項目

DatabaseRole2 Object

その他の技術情報

サブスクリプション管理プロジェクトの開始

ヘルプおよび情報

SQL Server 2005 の参考資料の入手