Question:
Why does the Owner not generate in my Forward Engineering Script even though the macro %TableOwner is stated in my Script Template?
Target Database: Oracle 11g/12c/18c
Prerequisites:
You can also create it at a Model level in which case it will be created a bit differently using the macro '%ForEachTable() {GRANT SELECT, INSERT, DELETE, UPDATE ON %TableOwner.%TableName ; } In that case you do not need to attach to any specific Table (steps for # 2 above) as it will be created for each Table at the end of the script generation in Forward Engineering.
Answer:
Result: The following script with Owner will appear after the "Create <Table Name>" statements: GRANT SELECT, INSERT, DELETE, UPDATE ON <Table Owner>.<Table Name> ;
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center