B Database Users and Privileges

Describes the Oracle Airlines Data Model users and privileges for OADM_SYS, OADM_SAMPLE, OADM_USER, and OADM_REPORT.

Parent topic: Appendices

Oracle Airlines Data Model Database Users and Privileges

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