USoft application tables

The purpose of a USoft user application is to allow end users to interact with data. These data are stored in USoft application tables.

You need to designate a database user in Production as the application owner. It is in the account of this user that the USoft application tables are going to reside.

Creating USoft application tables

To create USoft application tables:

1.	From the USoft development repository, generate an installation script which will create the application tables.

USoft has a specialised Delivery Manager tool that will create such an installation script for you.

2.	Create the application by running this script against the application owner's account.

3.	Load deliverable application data into the application tables if required. Deliverable application data are data that developers indicate must be delivered to Production machines. Typically, end users in Production are not allowed to create or change this data.

Authorising end users to use application tables

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.