USoft Application Tables

In the database of the production environment, assign a database user as the application owner. It is in the account of this user that the application tables are going to reside.

From the USoft development repository, generate an installation script which will create the application tables. Create the application by running this script against the application owner's account.

Load existing application data into the application tables if required.

Authorization for the production environment is set up in the same way as authorization for the development environment. That is:

•USoft Authorization tables are created for the application owner.

•Using these tables, end-users are registered and authorized by the application owner. In this way, authorization changes can be made dynamically (i.e. whilst the application is being used).

•This way of working requires that appropriate end-user access rights to the application owner's are also granted at RDBMS level.