SSAS 2012 2008 Creating Database Roles





How to Create Database Roles in SSAS analysis services 2008 and 2012 
  1. Analysis Services allows you to create roles in both Business Intelligence Development Studio and SQL Server Management Studio.
  2. Creating roles in SQL Server Management Studio means that the changes are performed on the deployed system and will take effect the next time the user connects to the Analysis Services instance. 
  3. Note that the change that is made through SQL Server Management Studio is not reflected within the Business Intelligence Development Studio project. 
  4. This results in the roles being overwritten or removed, should the deployment of the project define that the roles members are dropped and created from the project.
  5. This is why using Business Intelligence Development Studio is a better alternative for creating roles if you need to keep a record of the roles existence within the project file. 
  6. Roles that are created within Business Intelligence Development Studio need to be deployed but a record of the role will be kept in the project file.
  7. To create roles, you must be a member of the Server role. 

To create a role in SQL Server Management Studio, perform the following steps:

  1. Connect to an instance of Analysis Services.
  2. In Object Explorer, expand the Analysis Services database, right-click Roles, and then click New Role.
  3. In the New Role dialog box, in the Name box, type a name for the role.
  4. To add members, click the Membership tab, and then click Add.
To create a role in Business Intelligence Development Studio, perform the following steps:
  1. Open an Analysis Services solution in Business Intelligence Development Studio.
  2. In Solution Explorer, expand the Analysis Services project, right-click Roles, and then click New Role.
  3. In the New Role dialog box, in the Name box, type a name for the role.
  4. To add members, click the Membership tab, and then click Add.
The Role Designers are the same functionally. After the role has been named and the members added, you set the permissions the same way on both Role Designers

0 comments:

Post a Comment