...

1. Open the table properties in the source connection.
2. Click the SQL tab.
3. Scroll to the bottom of the SQL worksheet.
4. Copy the grant SQL commands.
   Only the grants for WRITER, GUEST, PUBLIC need to be copied. All others are unnecessary.
   Copy grant statements from destination connection
5. Paste these commands into the worksheet in the destination connection.
6. Modify all source schema names to destination schema name.
   

7. Execute and commit the grant SQL commands.
   This is the set that must be repeated for each table in the GEODP### schema.

   Code Block

   -- Add required Grants to Tables in New Project Schema GRANT DELETE ON "NEW-PROJ-SCHEMA"."TABLE_NAME" TO "WRITER"; GRANT INSERT ON "NEW-PROJ-SCHEMA"."TABLE_NAME" TO "WRITER"; GRANT SELECT ON "NEW-PROJ-SCHEMA"."TABLE_NAME" TO "WRITER"; GRANT UPDATE ON "NEW-PROJ-SCHEMA"."TABLE_NAME" TO "WRITER"; GRANT SELECT ON "NEW-PROJ-SCHEMA"."TABLE_NAME" TO "GUEST"; GRANT SELECT ON "NEW-PROJ-SCHEMA"."TABLE_NAME" TO PUBLIC; -- Example for the specific table P_CAPTURE_FILES in schema GEODPTST123 GRANT DELETE ON "GEODPTST123"."P_CAPTURE_FILES" TO "WRITER"; GRANT INSERT ON "GEODPTST123 "." P_CAPTURE_FILES " TO "WRITER"; GRANT SELECT ON "GEODPTST123"." P_CAPTURE_FILES " TO "WRITER"; GRANT UPDATE ON " GEODPTST123"." P_CAPTURE_FILES " TO "WRITER"; GRANT SELECT ON " GEODPTST123"."P_CAPTURE_FILES" TO "GUEST"; GRANT SELECT ON " GEODPTST123"." P_CAPTURE_FILES " TO PUBLIC;

   At this point the new project should be ready for use by GEODESC applications.

4. Register the new project in table GEODCAT.PROJECTS

...