none
analysis services.role创建角色 RRS feed

答案

  • Connect to ssas in ssms, right click on roles and choose new role. If it's what you are looking for.
    2011年6月21日 12:48
  • 在设计时刻也可以在SSAS 项目下的 角色(Roles)菜单下建立;

    当然也可以在SSMS中通过代码建立,假如你对XML/A熟悉的话,比如:

    <Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <ParentObject>
    <DatabaseID>TungerFinance</DatabaseID>
    </ParentObject>
    <ObjectDefinition>
    <Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
    <ID>Role 3</ID>
    <Name>ThieRole</Name>
    <Members>
    <Member>
    <Name>BuildingOneServer\RegularUsers</Name>
    <Sid>asdasdfasdf</Sid>
    </Member>
    </Members>
    </Role>
    </ObjectDefinition>
    </Create>


     

     

    2011年6月23日 15:53
    版主

全部回复

  • Connect to ssas in ssms, right click on roles and choose new role. If it's what you are looking for.
    2011年6月21日 12:48
  • 在设计时刻也可以在SSAS 项目下的 角色(Roles)菜单下建立;

    当然也可以在SSMS中通过代码建立,假如你对XML/A熟悉的话,比如:

    <Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
    <ParentObject>
    <DatabaseID>TungerFinance</DatabaseID>
    </ParentObject>
    <ObjectDefinition>
    <Role xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
    <ID>Role 3</ID>
    <Name>ThieRole</Name>
    <Members>
    <Member>
    <Name>BuildingOneServer\RegularUsers</Name>
    <Sid>asdasdfasdf</Sid>
    </Member>
    </Members>
    </Role>
    </ObjectDefinition>
    </Create>


     

     

    2011年6月23日 15:53
    版主