Pages

Thursday, May 17, 2018

Oracle Transport Management OTM Database Users

Oracle Transport Management OTM Database Users



-Archive
This user owns the DMP tables used for archiving the data. May not be deleted.

-GLOGDBA
This user has access to functions and packages owned by glogowner and reportowner, but does not itself own any tables, views, functions, or packages. It must call the vpd.set_user stored procedure to set user context to view data. May not be deleted.

-GLOGOWNER
This user owns OTM tables, views, functions and packages, can create or alter data structures within the database and can manipulate data. May not be deleted.

-GLOGLOAD
Used for loading data into glogowner and reportowner schemas. May not be deleted.

-DIR_XML_USER
This user should be use for Direct XML integration. This user has the minimum privileges to successfully insert XML transmissions into database objects when using the Direct XML integration feature.

-REPORTOWNER
This user owns the tables, views, functions and packages required for reporting, and can read the data. May not be deleted.

-GLOBALREPORTUSER
This user has read access to all the data in OTM. It is mainly used for reporting. May not be deleted.

-HDOWNER
This user owns FTI tables, views, functions and packages, can create or alter data structures within the database and can manipulate data. May not be deleted.

No comments:

Post a Comment