Hello,
We are looking for help on the implementation of SQL Command "grant" in HOPEX.
Currently users are using the commands PowerAmc bellow.
In green : commands that we managed to recreate in HOPEX.
In red : commands that we have not managed to recreate in HOPEX.
Questions :
Is it possible to create a Grant command in HOPEX ?
If it's possible, how can we do that ?
POWERAMC Commands used :
create sequence ACTIONINTERVENTION$SEQ
increment by 1
maxvalue 999999999
minvalue 1
cycle
nocache;
grant SELECT on ACTIONINTERVENTION$SEQ to OPERATEUR;
create table ACTIONINTERVENTION (
ID NUMBER not null,
LINTERVENTION NUMBER not null,
ELEMENTACTION VARCHAR2(30) not null,
ANCIENNEVALEUR VARCHAR2(60),
NOUVELLEVALEUR VARCHAR2(60),
ANCIENNEVALEUR2 VARCHAR2(60),
NOUVELLEVALEUR2 VARCHAR2(60)
grant SELECT on ACTIONINTERVENTION to CONSULTANT;
grant INSERT,UPDATE,DELETE on ACTIONINTERVENTION to OPERATEUR;
