Describes the Oracle Airlines Data Model users and privileges for OADM_SYS, OADM_SAMPLE, OADM_USER, and OADM_REPORT.
Parent topic: Appendices
Describes the Oracle Airlines Data Model users and privileges for OADM_SYS, OADM_SAMPLE, OADM_USER, and OADM_REPORT.
OADM_SYS and OADM_SAMPLE Privileges
OADM_SYS is the schema owner of OADM database objects and OADM_SAMPLE is schema owner of OADM database objects with sample data. The same set of privileges are set for both OADM_SYS and OADM_SAMPLE.
Table B-1 Database Users and Privileges: OADM_SYS and OADM_SAMPLE
Privilege | Justification |
---|---|
create materialized view |
To create materialized view in OADM_SYS and OADM_SAMPLE schemas |
create procedure |
To create procedure in OADM_SYS and OADM_SAMPLE schemas |
create sequence |
To create sequence in OADM_SYS and OADM_SAMPLE schemas |
create session |
To create session to execute SQL,PL/SQL scripts as OADM_SYS and OADM_SAMPLE users |
create synonym |
Synonyms are used as alternative table names |
create table |
To create table in OADM_SYS and OADM_SAMPLE schemas |
create tablespace |
To create tablespace in OADM_SYS and OADM_SAMPLE schemas |
create type |
To create type in OADM_SYS and OADM_SAMPLE schemas |
create view |
To create view in OADM_SYS and OADM_SAMPLE schemas |
create mining model |
To create mining model in OADM_SYS and OADM_SAMPLE schemas |
execute on ctxsys.ctx_ddl |
To use Oracle Text for customer sentiment analysis in OADM_SYS and OADM_SAMPLE schemas |
olap_user |
To create Analytic Workspace, cubes, and cube dimensions in OADM_SYS and OADM_SAMPLE schemas |
create dimension |
To create dimension in OADM_SYS and OADM_SAMPLE schemas |
create job |
for OADM_user to run olap package |
OADM_USER Privileges
The OADM_USER database user invokes the Intra-ETL packages and OLAP data loading.
Table B-2 Database Users and Privileges: OADM_USER
Privilege | Justification |
---|---|
create session |
To create session to invoke Intra-ETL packages and OLAP data loading. |
execute on |
Privilege to invoke Intra-ETL packages and OLAP package owner by OADM_SYS schema |
OADM_REPORT Privileges
The OADM_REPORT database user invokes OBIEE services to query data from the OADM_SYS schema and return query results back to OBIEE services.
Table B-3 Database Users and Privileges: OADM_REPORT
Privilege | Justification |
---|---|
create session |
To create session to query data from OADM_SYS schema. |
select on |
Select privilege on OADM_SYS tables, views, cubes, and cube dimensions. |
Parent topic: Database Users and Privileges