Step 3. Creating the HxGN EAM database user - HxGN EAM - Version 11.7.1 - Installation & Upgrade - Hexagon

HxGN EAM Oracle Database Installation Guide

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
11.7.1

Create the HxGN EAM database user by running the 00cu117i.sql script while logged on as Oracle user SYS or as another user with DBA privileges. The script prompts you for username, password, data tablespaces, index tablespaces, and temp tablespaces and then grants the required privileges to the HxGN EAM user.

HxGN EAM requires access to several SYS packages and the V$SESSION data dictionary view. Permissions for this access are granted from the Oracle SYS user. If you do not want to run scripts as the SYS user, you can run the installation grants from a DBA account with access that includes the "grant option." This procedure allows this DBA to grant required privileges to the alternative dba user in lieu of SYS. Execute the following SQL statements as SYS to grant the needed privileges to the alternative dba account:

grant select on v_$session to &&dba_user with grant option;

grant create job to &&dba_user with admin option;

grant execute on dbms_job to &&dba_user with grant option;

grant execute on dbms_sql to &&dba_user with grant option;

grant create type to &&dba_user with admin option;

grant create user to &&dba_user;

grant create table to &&dba_user with admin option;

grant create view to &&dba_user with admin option;

grant create procedure to &&dba_user with admin option;

grant create session to &&dba_user with admin option;

grant create trigger to &&dba_user with admin option;

grant query rewrite to &&dba_user with admin option;

grant query rewrite to &&dba_user with admin option;

grant create sequence to &&dba_user with admin option;

grant select on sys.dba_pending_transactions to &&dba_user with grant option;

grant select on sys.pending_trans$ to &&dba_user with grant option;

grant select on sys.dba_2pc_pending to &&dba_user with grant option;

grant execute on sys.dbms_xa to &&dba_user with grant option;

grant force transaction to &&dba_user with grant option;