1.2 Create User Grants

You need to create the user grants in the necessary schemas to setup the database-related configuration for Oracle Banking Branch.

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-19 Grants Provided to the Users

Schema Grants

Oracle Banking Branch 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;

View creation grants:

In addition to the above grants provided to the user, you can add view creation grant in the BRANCH schema as follows:

  • grant create synonym to BRANCH;
  • grant create procedure to BRANCH;
  • grant create sequence to BRANCH;
  • grant create job to BRANCH;
  • grant create view to BRANCH;
  • grant create mining model to BRANCH;

  • grant create any mining model to BRANCH;

  • grant alter any mining model to BRANCH;

  • grant drop any mining model to BRANCH;

  • grant select any mining model to BRANCH;

  • grant comment any mining model to BRANCH;

  • grant execute on DBMS_DATA_MINING to BRANCH;

  • grant create table to BRANCH;

  • grant create session to BRANCH;

  • grant create type to BRANCH;