Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 roles access

Author  Topic 

nghorakavi
Starting Member

3 Posts

Posted - 2007-09-29 : 19:05:48
Hi

I wanted to get the script for all the roles.

we have around 500+roles are present.
The role name is like this.

SMSGPL_SMSG_38_Write->
SMSG_38 stands out for Entity.like that we will have around 100+ Entities. This role is granted to the user corresponding Geography.
I would like to compare the users and roles in the cube compared to Users and role in the database.
how can I do this?.
1. I am looking here to get the script for all the roles in the cube.


Thanks
Narasimha.
   

- Advertisement -