THIS PAGE IS SLATED FOR RETIREMENT. SEE ITS SIBLING PAGES.

A GEODESC project is effectively implemented as an Oracle schema.  To create a GEODESC project a user will perform the following tasks:

1. Create the schema account in Oracle.
2. Clone the tables, views, sequences, indexes, etc. from a "base" project (currently the base project is a pre-existing project.  In the near future we will create a special-purpose project labeled as "base").  Important: when cloning the base project copy the DDL only, do not copy any data from the source schema)
   df Recommendation - store this BASE project in a DMPDP file. Script SQL to load and rename as-needed from the OEMJR:/backup/export/ directory.
3. Issue the proper grants to resources in the new project.
4. Add the newly created GEODESC project to the GEODCAT.PROJECTS table (this will cause it to show up in the "projects" dropdown for GEODESC applications.
5. Create new role and associated privilege for the new project.

Create Oracle Schema account

1. Using SQLDeveloper, sign into Oracle with your DBA account
2. Right click “Other users” icon, select “Create user…”
3. “User Name” must start with prefix “GEODP”; e.g. “GEODP123” for Expedition 123 project.
4. Create an appropriate password for the new account.
5. Use one of the other schema accounts as a guide to include the appropriate user settings and grants. Settings should be similar to:
   1. Granted Roles:
      1. Connect
   2. System Privileges:
      1. Advisor
      2. Alter session
      3. Create Credential
      4. Create Database Link
      5. Create Job
      6. Create Procedure
      7. Create Public Synonym
      8. Create Sequence
      9. Create Session
      10. Create Synonym
      11. Create Table
      12. Create Trigger
      13. Create Type
      14. Create View
      15. Create Any Procedure
      16. Debug Connect Session
      17. Drop Public Synonym
      18. Select Any Dictionary
      19. Select Any Table
   3. Quotas
      1. LABWARE
      2. LABWAREIDX
      3. USERS |  31457280 | K

...

Add the newly created schema account credentials to shipboard password safe.

Copy DDL from Existing Project to New Project

In this example we will copy DDL from existing schema owner GEODPTST360 to new, target, project schema GEODPTST123.

...

SQLBuilder will run a utility that copies all of the DDL from the source account to the destination account; i.e., it will build all the tables, constraints, indexes, sequences, etc. required for the new project.  At the end of the process SQLBuilder will display a log of all of the actions that occurred.  Review this log and look for errors or warnings.

Add required Grants to Tables in New Project Schema

For each table in the new project schema run the following GRANT SQL commands:

...