PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Applying Grants in DDL Model defaults

edited Aug 31, 2018 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center