A GEODESC project is effectively an Oracle schema. To create a GEODESC project a user will perform the following tasks:
- Create the schema account in Oracle.
- 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)
- Issue the proper grants to resources in the new project.
- 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.
- Create new role and associated privilege for the new project.
Create Oracle Schema account
...