Secure Existing Database
You can institute a Security schema for a database that has already been created. In this scenario, you may have fully created the Meta Data and loaded the most up-to-the-instant Fact Data—but you now want to assign privileges to the various users who will access the database. Before granting those privileges, you must indicate that this will be a Secure Database.
1. For a database that already exists (e.g., Avon Trading Company), open the database by clicking on File icon and selecting Open Database command and browsing for the database.
2. 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.
3. Check the Secure Database box at the top right (shown boxed in the following figure).
4. Click OK.
The following message box appears:
5. Click OK.