Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Add members to a role by script in tabular model Expand / Collapse
Author
Message
Posted Friday, July 18, 2014 10:37 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:28 PM
Points: 76, Visits: 1,217
How can I add members to a role by script in the tabular model? I have the role set up, and I have a security table created that contains the domain/userid of all of the users that I'd like to add to that role. Can this be done by script rather than manually?

Thanks,
Jill



Post #1594153
Posted Sunday, August 3, 2014 1:16 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 4:47 AM
Points: 86, Visits: 100
yes this is possible , u can script ur roles out as ALTER Option and then run it in batch xmla command (which contains all alter commands)
Example:-

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
<Object>
<RoleID>Role 2</RoleID>
<DatabaseID>CUBEDBID</DatabaseID>
</Object>
<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" xmlns:ddl300="http://schemas.microsoft.com/analysisservices/2011/engine/300" xmlns:ddl300_300="http://schemas.microsoft.com/analysisservices/2011/engine/300/300" xmlns:ddl400="http://schemas.microsoft.com/analysisservices/2012/engine/400" xmlns:ddl400_400="http://schemas.microsoft.com/analysisservices/2012/engine/400/400">
<ID>Role 2</ID>
<Name>ROLE_DIV_MKT_OPRN</Name>
<Description>Access to everything</Description>
<Members>
<Member>
<Name>AMR\AD_SMS_DIV_MKT_OPRN</Name>
</Member>
</Members>
</Role>
</ObjectDefinition>
</Alter>

</Batch>
Post #1599070
Posted Monday, August 4, 2014 12:35 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 12:28 PM
Points: 76, Visits: 1,217
Thank you, but I guess that my question was not clear. I want to only add new members to an existing role; I don't want to have to list all of the existing members in the role. I want to keep all of the existing members, without scripting them out, but just add the new ones by script.


Post #1599364
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse