Restricted User

From GeoMedia Smart Client
Jump to: navigation, search



Blue.pngThe following sql statements allowing you define a restricted role for GMSC.




CREATE ROLE GMSC_RUNTIME_ROLE;
GRANT CREATE SESSION TO GMSC_RUNTIME_ROLE;
 
GRANT GMSC_ROLE TO GMSC;
 
REVOKE GMSC_ROLE FROM GMSC;
GRANT GMSC_RUNTIME_ROLE TO GMSC;


Blue.pngPrior to future upgrades of GMSC installations you have to switch back to the GMSC_ROLE.



REVOKE GMSC_RUNTIME_ROLE FROM GMSC;
GRANT GMSC_ROLE TO GMSC;



Language: English