1. Installation Guide
  2. Setup Database
  3. Create User Grants

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 BRANCHTLR schema as follows:

  • grant create synonym to BRANCHTLR;
  • grant create procedure to BRANCHTLR;
  • grant create sequence to BRANCHTLR;
  • grant create function to BRANCHTLR;
  • grant create job to BRANCHTLR;
  • grant create view to BRANCHTLR;

  • grant create mining model to BRANCHTLR;

  • grant create any mining model to BRANCHTLR;

  • grant alter any mining model to BRANCHTLR;

  • grant drop any mining model to BRANCHTLR;

  • grant select any mining model to BRANCHTLR;

  • grant comment any mining model to BRANCHTLR;

  • grant execute on DBMS_DATA_MINING to BRANCHTLR;

  • grant create view to BRANCHTLR;

  • grant create table to BRANCHTLR;

  • grant drop table to BRANCHTLR;

Parent topic: Setup Database