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.
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) |
|
Common Core Schema (common core grants) |
|
SMS Schema (SMS grants) |
|
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;
Parent topic: Setup Database