Account Management

When is started for the very first time a default database Cassiopeia is created on localhost. In the database a user/schema ROOT is created and filled with all required tables and columns. After this fully automated setup process has completed can be used and the database accessed by logging in with the default account ROOT (no password).

This tutorial explains how to create additional users, set passwords, assign access privileges and how to log into Cassioleia using a non-ROOT user account.

  • Creating user accounts and setting passwords
  • Logging in as a normal user

Creating user accounts and setting passwords

You can use either which is part of the FrontBase installation or which is part of the Cassiopeia installation to create user accounts and set passwords. Since can also be used to assign access privileges and set multi-user licenses as discussed further below we will make use of in this tutorial.

Open and open the Preferences panel.

In my case the correct database is already set. In the general case it has to be selected by clicking on Set.

Type localhost (or the ipaddress of your remote FrontBase database server) in the Host name field and press Enter. The hostname appears in the left column, all databases available on this host in the right column.

Click on the database you want to administer and then on Select. In this example we will administer the database Cassiopeia on localhost.

Once the correct database is set close the preferences panel and choose Database - Log On from the AccountManager menu.

If a password for the default account ROOT has been set (see below) enter it in the User password field. Otherwise leave the password field blank and simply click on OK.

You might want to set a password for the super user account now. Click on ROOT or _SYSTEM in the user tableview and then on Set Password.

Enter the same password in the New Password and Verify Password field and click on Set Password.

Note that if you change the password of the super user ROOT the same password is automatically set for _SYSTEM and vice versa. That's important. If you ever set passwords using make sure to set the same password for these two super user accounts. Please remember the password you set for the ROOT/_SYSTEM combo. There is no way to access the database again if the super user password gets lost (not entirely correct, FrontBase support might be able to help in such a case, but be careful anyway).

Click on Create User now to create the first normal user account.

Choose whatever username you like. However, it's a good idea to use the same usernames you also use for the MacOSX accounts. My MacOSX account is ahoesch with /Users/ahoesch being my home directory. I therefore choose ahoesch for my personal database account.

Set a password for this new account and click on Create User again to create accounts for all users that intend to access the database. Note the default group Staff in the lower left tableview. This group has automatically been created during the automated setup procedure. On the right of the group tableview is another tableview with the users assigned to the selected group. Control-drag all normal users from the top left tableview to the bottom right tableview and thus assign them to the default group Staff.

Hit Save to save changes. Switch to the second pane of the tab view.

The Access Privileges pane shows all available forms in the top and the forms assigned to a specific group (or user) in the bottom. The automatic setup procedure has assigned all available forms to group Staff with delete privilege. You can create other groups with other privileges assign users to this other group and thus determine which user has access to which form with what privileges. For the sake of this tutorial we are happy with the users AHOESCH and RJESSAT having access to all forms with delete privilege.

Logging in as a normal user

Restart Cassiopeia and choose Database Log On from the menu.

Replace the default username ROOT with the username of one of the accounts you created above and enter the corresponding password in the password field.

Then click on OK. The Obejct Browser windows appears as usual. Choose SDM - Organisation - Document Manager and create a new document.

Note that the OWNER column now gives AHOESCH instead of ROOT. Save changes and press Command-Shift-B to bookmark this document. An alias appears on the Object Browser window.

Ctrl-Shift-Doubleclick on the alias. This raises the privileges inspector for the document.

The privilges inspector allows to modify the owner of the document and to set access privileges fo rthe owner and other database users. Note that documents are accessible by the owner only by default. If you want to grant update access to all users in your group and read only access for all others database users set the checkboxes accordingly and save changes.

Terms and Conditions          © Smartsoft GmbH 2019