9/11/2009 (16 years ago) | |
Clarify | |
Any | |
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