14 lines
459 B
SQL
14 lines
459 B
SQL
CREATE OR REPLACE TABLE RESTAPI.NAME_MAP (
|
|
RAW_TOKEN VARCHAR(128) CCSID 37 NOT NULL ,
|
|
DISPLAY VARCHAR(128) CCSID 37 NOT NULL ,
|
|
CONSTRAINT RESTAPI.Q_RESTAPI_NAME_MAP_RAW_TOKEN_00001 PRIMARY KEY( RAW_TOKEN ) )
|
|
|
|
RCDFMT NAME_MAP ;
|
|
|
|
GRANT ALTER , DELETE , INDEX , INSERT , REFERENCES , SELECT , UPDATE
|
|
ON RESTAPI.NAME_MAP TO AMAPICS WITH GRANT OPTION ;
|
|
|
|
GRANT DELETE , INSERT , SELECT , UPDATE
|
|
ON RESTAPI.NAME_MAP TO PUBLIC ;
|
|
|