Disable Security
There may be an occasion when you want to remove all Security from a database. You will need Administrator privileges to proceed as follows:
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. Uncheck the Secure Database box
(as shown, boxed in the following figure):
3. Click OK.
Notes
Once Security has been disabled, it can be re-instituted (follow steps, Secure Existing Database); the same Security rules will apply, provided no rules were changed when the database was in its unsecured state.