Assigning Database Privileges
Once you have defined Users and Groups, you must define Meta Data and Fact Data privileges—without granting privileges, no User/Group can see or do anything with the database (except for those placed in the Administrator Group)!
Privilege to Add Dimensions and Cubes
We can begin by granting a unique privilege to a User or Group—the ability to create new Dimensions (Members, Hierarchies) and Cubes (and Formulas). The operative word here is “new”—the User will not be able to see pre-existing Dimensions and Cubes (and their Fact Data) until additional Meta Data and Fact Data privileges are granted to do so. [See tip below for further information about the ramifications of this privilege.]
1. In the PowerOLAP ribbon, go to Model tab, then in the Security control group select Database Privileges icon or Maintain Database Privileges command.
The Database Security dialog box appears.
2. Select a User or Group.
3. Click in the Can add Dimensions and Cubes check box at the bottom right (circled in the following figure).
4. Click OK.
It bears repeating that a User/Group that has this privilege (Can add Dimensions and Cubes) may still need to be given privileges to access other Meta Data and Fact Data pre-existing in the database in order to build certain Cubes. Alternatively, in another scenario, if no pre-existing Meta Data and Fact Data exists in the database, this User might be the user given responsibility to construct the key components (or all components) of the database that others will see.
Further, note that a user given database privileges to Add Dimensions and Cubes will thereafter have full privileges to those Dimensions and Cubes.