7 Administration of SuperOffice Users

SuperOffice needs at least one administrator. An administrator is a user which have user level = 0.
The SuperOffice registration procedure shown below creates the SuperOffice administrator.

Before the SuperOffice administrator can create any new SuperOffice employee (user)
Database administrator should run the following script

    GRANT GRANT ANY ROLE TO SOADMIN;

8 Using User-defined Table
This section describes what you need to do to use user-defined tables in superoffice in oracle environment.

Database administrator must run the following script each time the user-defined table is altered in superoffice due to grant permission to manipulate data in these tables. Database administrator can use SQL*Plus to run the following script

    GRANT SELECT, UPDATE, INSERT, DELETE ON SO.udcontact1 TO SOUSER;
    GRANT SELECT, UPDATE, INSERT, DELETE ON SO.udcontact2 TO SOUSER;
    GRANT SELECT, UPDATE, INSERT, DELETE ON SO.udcontact1 TO SOADMIN;
    GRANT SELECT, UPDATE, INSERT, DELETE ON SO.udcontact2 TO SOADMIN;