Login

Solution #387 - What happens when a new table is added by Dovetail SchemaEditor?

9/11/2009 (16 years ago)
Clarify
Any
Not yet rated.
5/16/2024 (10 months ago)
Windows (Any)
Any

What happens when a new table is added by Dovetail SchemaEditor?

Resolution 16 years ago

When a new table is added by Dovetail SchemaEditor:

  • the appropriate data is inserted into the ADP tables
  • the table is created at the database level
    e.g. CREATE TABLE table_my_custom_table (objid integer,...)
  • an index is created for the objid column
    e.g. CREATE UNIQUE CLUSTERED INDEX objindex ON table_my_custom_table (objid)
  • grants are added to the table (insert, update, select, delete)
    e.g.
GRANT SELECT, UPDATE, INSERT, DELETE on table_my_custom_table to cl_user
GRANT ALL on table_my_custom_table to administrator
GRANT SELECT on table_my_custom_table to reporter
  • for Oracle, a public synonym is added for the table

You must be logged in to post a comment.

Login
  • SchemaEditor

    Application for modifying and extending a Clarify/Dovetail database schema

You must be logged in to post a comment.

Login