• [アーティクル]

DatabaseRoles Collection

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

The DatabaseRoles collection contains DatabaseRole objects that expose Microsoft SQL Server security privilege roles defined within a database.

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

説明

A SQL Server database role can contain one or more members (database users). A properly authenticated user can create database roles; add members or remove them from the role; and grant or deny database privileges to the role to administer privileges for one or more users, logically organized. With the DatabaseRoles collection, you can:

  • Create a SQL Server database role.

  • Remove a SQL Server database role.

For more information about creating database roles, see the DatabaseRole Objectsection.

To remove a database role

  1. Use the DropMember method of the DatabaseRole object to remove all members from the role.

  2. Use the Remove method of the DatabaseRoles collection to remove the role from the SQL Server database, as in:

    oDatabase.DatabaseRoles.Remove("Clerical")
    注意注

    You cannot remove a database role from a SQL Server database if the role contains members. The EnumDatabaseRoleMember method of the DatabaseRole object can be used to list the current members of a role. Use the results of the method to remove members, then remove the role.

When using the Item or Remove method, the DatabaseRoles collection supports member identification using either name or ordinal reference syntax. For example:

Set oDatabaseRole = oDatabase.DatabaseRoles("Clerical")

Or

Set oDatabaseRole = oDatabase.DatabaseRoles(4)
注意注

Inspecting or modifying database roles using the DatabaseRoles collection requires appropriate privilege. The SQL Server login used for SQLServer object connection must be a member of the fixed role db_securityadmin or a role with greater privilege.