clsRoleCommand

注意：
下一版本的 Microsoft SQL Server 将删除该功能。请不要在新的开发工作中使用该功能，并尽快修改当前还在使用该功能的应用程序。

An object of ClassType clsRoleCommand provides a specific implementation of the Command interface. These objects provide collections and properties through the Command interface. There are no methods associated with an object of ClassType clsRoleCommand.

备注

An object of ClassType clsRoleCommand encapsulates a user-defined command that is automatically executed on the Microsoft® SQL Server™ 2000 Analysis Services client computer when a cube is accessed by members of the specified role. You add a command to a role by adding it to the role's Commands collection. Such commands include calculated members, named sets, library references, and others.

For example, you may want to grant access to a calculated member called SalesBonusto members of the Manager role but not to members of the SalesPerson role. The command that builds the SalesBonus calculated member is automatically executed for members of the Manager role when they access a cube that contains that role command.

示例

Use the following code to create an object of ClassType clsRoleCommand:

'Assume an object (dsoDB) of ClassType clsDatabase exists
Dim dsoRole As DSO.Role   'Role
Dim dsoCmd As DSO.Command   'Command

Set dsoRole = dsoDB.Roles(1)
Set dsoCmd = dsoRole.Commands.AddNew("RoleCmd1")

请参阅

参考

Collections, clsRoleCommand
Command Interface
Properties, clsRoleCommand

其他资源

Commands

帮助和信息

获取 SQL Server 2005 帮助