Showing results for 
Search instead for 
Do you mean 

What rights need to be granted to an Oracle user in order to use GeoMedia Transaction Manager functionality?

by Technical Evangelist on ‎03-15-2016 01:16 PM - edited on ‎04-07-2016 06:17 AM by Moderator (440 Views)

Question

What rights does an Oracle user need to be granted in order to use the GeoMedia Transaction Manager functionality for a given schema's tables when working with revision sets?

Answer

If Schema_A owns a feature class, and have secured such a feature class, Schema_A should grant the following privileges to another schema ( e.g Schema B) , to enable Schema_B to edit Schema_A's secured features:

grant select, update, insert, delete on _LT to "Schema_B";
grant select, update, insert, delete on  to "Schema_B;
grant select on _HIST to "Schema_B";
grant select on _LOCK to "Schema_B";
grant select on _MODS to "Schema_B";
grant  SELECT on _USEQ to "Schema_B";
grant  SELECT on _FSEQ to "Schema_B";
grant SELECT on _ID_SEQ to "Schema_B";

There is a GTMUTIL package in the GOOM collection that has procedure to automatically handle privilege assignments for version enabled tables.

Contributors