1.2 Create User Grants

User needs to create the user grants in the necessary schemas to setup the database-related configuration for Oracle Banking Retail Lending Servicing.

Make sure that the database setup and database link creation are completed as specified in Setup Database.

The common grants, common core grants, and Security Management System (SMS) grants are provided to the users. For more information on default grants provided to the users, refer to the table below.

Table 1-24 Grants Provided to the Users

Schema Grants

Oracle Banking Retail Lending Servicing schema (common grants)

  • grant create session to PLATO;

  • grant create table to PLATO;

  • grant create sequence to PLATO;

Common Core Schema (common core grants)

  • grant create procedure to CMNCORE;

  • grant create synonym to CMNCORE;

  • grant create sequence to CMNCORE;

  • grant create function to CMNCORE;

SMS Schema (SMS grants))

  • grant create synonym to SMS;

  • grant create procedure to SMS;

  • grant create sequence to SMS;