1. Database Installation Guide
  2. Setup and Configuration of the Database Server
  3. Create Users and Granting Access

1.4 Create Users and Granting Access

Creating the user INTERNAL. This user is required for batch job process, webservices and to start services.

A script is provided in the distribution media in the dba_utils folder to create an user. Run the script crt_app_user.sql script as a OFSLL application owner user.

Figure 1-19 Command prompt window 18


Description of Figure 1-19 follows
Description of "Figure 1-19 Command prompt window 18"

Granting OFSLL Screen / Web Service Access to Application Users (New In­stallation only)

Post user creation, to access all the 'Screens' and 'web service' for a specific responsibility, login as an application schema owner and do the following:

1. Execute the below SQL statement:

TRUNCATE TABLE FLS_ACCESS_DETAILS;

Figure 1-20 Command prompt window 19


Description of Figure 1-20 follows
Description of "Figure 1-20 Command prompt window 19"

2. Execute the following db script available in dba_utils folder.

set_screen_access.sql

In the prompt, enter the user responsibility. You can also specify ALL to provide screen / web service access to all the created users in bulk.

In the next prompt source(UI/WS), enter one of the following:
  • UI to provide screen access to either All or specific user responsibility.
  • WS to provide web service access to either All or specific user responsibility.

Figure 1-21 Command prompt window 20


Description of Figure 1-21 follows
Description of "Figure 1-21 Command prompt window 20"

Further, you can customize the access through Setup > User > Access screen - Screen and Webservice tabs, as detailed in setup guide.

Granting user access to Reports, Transactions, & Correspondence.

Post user creation, to access all the Reports, Transactions, Correspondence for a specific responsibility, login as an application schema owner and execute the following db script available in dba_utils folder.

set_rpt_txn_cor_access.sql

In the prompt, enter the user responsibility. You can also specify ALL to provide screen access to all the created users in bulk.

Figure 1-22 Command prompt window 21


Description of Figure 1-22 follows
Description of "Figure 1-22 Command prompt window 21"

Further, you can customize the access through Setup > User > Access screen as detailed in setup guide.

Note:

In case where the application schema is created using an export and import utility, please reset the sequences by executing upgrade_fix_reset_all_sequences.sql file available in the data fix folder of the media. This helps to reset all the sequences to the current level.

Parent topic: Setup and Configuration of the Database Server