Applying Grants in DDL Model defaults
Has anyone used the following modification to DDL Model Defaults to successfully apply Grants at table build time?
CREATE TABLE [TBNAME] ([TBCOLLIST]) TABLESPACE [TBSPCNAME] STORAGE (INITIAL **INIT** NEXT **NEXT** MAXEXTENTS **MAXEXT** PCTINCREASE **PCT**) PCTFREE **PCTFREE** PCTUSED **PCTUSED**;
GRANT SELECT ON [TBNAME] TO MYROLE;
It not only doesn't work, it crashes the App Designer at build time. Is there some trick to it?