How to Share an Application with Multiple Users

Previous Next

See Also

In a USoft Binder file, a database user has to be specified to access the USoft applications. If you want to share an application with multiple users, you have to create a database account for each user, and then use the Authorizer to grant these users the appropriate rights. This is described in detail below:

To grant multiple users for an application:

Assume the APPOWNER database user is owner of a USoft repository and application and you want to grant a new APPUSER database user the same rights:

1. Create a database account for the APPUSER user in the appropriate database vendor product.


The APPUSER user has to have a CREATE ROLE privilege.

2. Open the Authorizer for the APPOWNER user.
3. Select Define, Application Users from the menu bar.
4. Insert the APPUSER user, with Validation Agent set to RDBMS.
5. Add the APPUSER to the appropriate User Groups, at least to the USAUTH and USD applications, and to the user application.
6. Select Define, Application Users from the menu bar, and query for the APPUSER user.
7. Click the Update button.
8. From the Tools menu, choose the option corresponding to the "level" at which you want to update the rights (Application, User Group, or User).

The appropriate dialog appears.

9. Complete the dialog as follows:
· Enter the Application, User Group, and User names, as appropriate, or click the Lookup button and choose one from the list that appears.


· Check or clear the From file checkbox to indicate whether you want the definitions of the application read from the flat file on your computer, or from the repository in which the application was developed.


· If you check the From file checkbox, you can change the name of the file from which the application definitions are to be read into the Conceptual File field.


· If you want the grants to be sent directly to the database, leave the Output File field empty. If you want the necessary statements to be put in a script file, type a filename or use the Browse button. If you do not specify a directory, the file will be created in the APP subdirectory of your USoft installation directory.
10. Open a new USoft Binder file, and enter the credentials for APPUSER, and set the owner to APPOWNER.