Roles Collection

ms133845.note(zh-tw,SQL.90).gif附註:
  下一版的 Microsoft SQL Server 將不再提供此功能。請勿在新的開發工作中使用此功能,並且儘速修改使用此功能的應用程式。

The Roles collection holds the user role definitions for a Decision Support Objects (DSO) object. Each of the following objects contains a Roles collection:

  • clsDatabase
  • clsCube
  • clsMiningModel

Each Roles collection contains role objects of the same class type. The ContainedClassType property of a Roles collection specifies the class type of the contained objects.

Class type Contained class type

clsCube

clsCubeRole

clsDatabase

clsDatabaseRole

clsMiningModel

clsMiningModelRole

備註

As with other DSO collections, the AddNew, Find, and Remove methods of Roles collections maintain all necessary parent-child relationships among the objects in the object model.

ms133845.note(zh-tw,SQL.90).gif附註:
  The UsersList property is maintained by clsDatabaseRole, and the Permissions property is maintained by clsCubeRole.

請參閱

參考

Methods, clsCollection
Properties, clsCollection
Collections (DSO)
Permissions (Role Interface)
UsersList (Role Interface)

說明及資訊

取得 SQL Server 2005 協助