Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Role (Decision Support Objects)

NoteNote

  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 Role object in Decision Support Objects (DSO) provides access to role-based security for databases, cubes, and data mining models. The DSO Database, Cube, and MiningModel objects all support the Roles collection, making security functions available for each DSO object.

All three types of roles are supported with DSO objects. Each role object detailed in the following table uses the Role interface, with the ClassType property set to the appropriate value for the role type as shown.

Role type

Role object

Role class type

Database role

DbGroup

clsDatabaseRole

Cube role

CubeGroup

clsCubeRole

Mining model role

MiningModelGroup

clsMiningModelRole

The Role object is used to:

  • Provide access to the list of users for a role associated with a database, cube, or data mining model.

  • Create or modify permissions on a role associated with a database, cube, or data mining model.

  • Provide access to commands for a role associated with a database, cube, or data mining model.

Community Additions

ADD
Show:
© 2015 Microsoft