Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

A GEODESC project is effectively 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)
  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

...