Minimum privileges scripts for Oracle 12
Minimum permission scripts are shipped and can be obtained from the IRC Adapters folder under Oracle\Minimum Permissions folder. The table below lists the scripts required for each Configuration Insight:
Insight name | Minimum privileges scripts |
---|---|
System Configuration |
Createsynonym-sys-12.0.sql Grantrole-sys-12.0.sql |
Financial Close |
OracleFCLPCI_create_synonyms-for12.0.sql OracleFCL_PCI_grant_select-for12.0.sql |
Order to Cash |
OracleO2CPCI_create_synonyms.120.sql OracleO2CPCI_grant_select_120.sql For Oracle v12.1.3 OracleO2CPCI_grant_select_1213.sql OracleO2CPCI_create_synonyms_1213.sql |
Procure-to-Pay | OracleP2PPCI_create_synonyms_120.sql
OracleP2PPCI_grant_select_120.sql |
Payroll |
OraclePAYPCI_create_synonyms.sql OraclePAYPCI_grant_select.sql |