Secure New Database
1. First, create a new database by clicking on the File button in the PowerOLAP application window and selecting the New Database command.
2. Enter a name for the new database (e.g., NewDBSecure) and browse for a location where the database will be saved.
3. Enable the Secure Database check box, boxed in the figure below.
4. Click OK.
5. Enter a <User Name> (a default is initially supplied, based on your Windows networking User Name) and enter and confirm your <Password>.
User Name is not case-sensitive, but Password IS CASE SENSITIVE. A Password must be at least eight (8) characters.
6. Click OK. You are returned to the main PowerOLAP window.
If you establish Security when you create a new database, the User Name you use (in the example, YourName) will automatically be placed in the Administrator Group, with full privileges to every aspect of the database, as discussed immediately following (How to manually create and place Users in Groups, and how to assign privileges, will be explained later in this section).
7. In the PowerOLAP ribbon, go to Model tab, then in the Security control group select Users and Groups icon or Maintain Users & Groups command.
The User & Groups dialog box appears.
There is always a user that is created in a Secure Database, named Administrator, who appears in the Administrator Group. The default password for Administrator is, likewise, “Administrator” (no quotes). A user with Administrator privileges may change any user’s Password (including his own) and define every aspect of other users’ access to database information, and may delete users. However, the user Administrator can neither be deleted from the database nor moved out of the Administrators Group (Nor can the Administrator Group be deleted or renamed).
8. If you are following the example, click OK.