Showing results for 
Search instead for 
Do you mean 

GeoMedia G/Technology Data Server database schema privileges

by Technical Evangelist on ‎08-24-2016 06:51 AM (593 Views)

Question

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;
Contributors