1. Installation Guide
  2. Set up Database
  3. Create User Grants

1.2 Create User Grants

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

Make sure that the database setup and database link creation are completed as specified in Set up 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-22 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 procedure to CMNCORE;

SMS Schema (SMS grants)

  • grant create synonym to SMS;

  • grant create procedure to SMS;

  • grant create synonym to SMS

View creation grants:

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

  • grant create mining model to PROJECTION;

  • grant create any mining model to PROJECTION;

  • grant alter any mining model to PROJECTION;

  • grant drop any mining model to PROJECTION;

  • grant select any mining model to PROJECTION;

  • grant comment any mining model to PROJECTION;

  • grant execute on DBMS_DATA_MINING to PROJECTION;

  • grant create view to PROJECTION;

  • grant create table to PROJECTION;

  • grant drop table to PROJECTION;

Parent topic: Set up Database