Why am I not seeing G/Technology database changes in GM?
Answer
In order for non-Admin, non-SchemaOwner users to view new or edited features posted in the G/Technology database, it is important to grant the users appropriate schema privileges.
For example,
In Oracle SQLPlus (or other Oracle tools), log in as the system admin user, run the following SQL statements –
Create public synonym GDT_COMPVIEWMODLOGINFO for <SchemaOwner>.GDT_COMPVIEWMODLOGINFO;
CREATE USER MYUSER
IDENTIFIED BY MYPASSWORD
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 8 System Privileges for MYUSER
GRANT MERGE ANY VIEW TO MYUSER;
GRANT SELECT ANY TABLE TO MYUSER;
GRANT SELECT ANY SEQUENCE TO MYUSER;
GRANT SELECT ANY DICTIONARY TO MYUSER;
GRANT CREATE SYNONYM TO MYUSER;
GRANT CREATE SESSION TO MYUSER;
GRANT EXECUTE ANY PROCEDURE TO MYUSER;
GRANT EXECUTE ANY TYPE TO MYUSER;
-- 1 Object Privilege for MYUSER
GRANT INSERT, SELECT ON GDT_COMPVIEWMODLOGINFO TO MYUSER;
