Role (Decision Support Objects)
[!참고]
이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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.