Share via


Roles Collection

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

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

Remarks

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.

Note

  The UsersList property is maintained by clsDatabaseRole, and the Permissions property is maintained by clsCubeRole.

See Also

Reference

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

Help and Information

Getting SQL Server 2005 Assistance