http://kb-index.mercury.com/web/queries/KBAview.asp?Product=TD&Conceptid=7093&BVUserID=
Problem Description: How does TestDirector create Oracle projects
Here are the SQL statements that the Project Administration Utility / Site Administrator uses to create new Oracle projects in case a user wants to know why TestDirector needs the system account privileges for Oracle server, or any user with "connect," "resource with admin option," "grant any role," "create user," and "select on_dba_free_space."
Please also refer to this article for SQL statements to run: Problem ID 7095 - How to create user in Oracle to create new Oracle projects.
Solution: SQL statements used by TestDirector to create projects
Here are the five examples of the SQL statements:
1. The user must have enough privileges to create the TDProject user and assign it to a table space:
CREATE USER td_manual IDENTIFIED BY [default password] DEFAULT TABLESPACE TD_PROJECTS TEMPORARY TABLESPACE TD_TEMP;
(Please contact Mercury support for the default password.)
2. The user must be able to grant the TDProject user these roles:
GRANT CONNECT,RESOURCE TO td_manual;
3. The user must have privileges to create Tables, Indexes, and Views:
CREATE TABLE ACT_DEPEND ( AD_ACTION_NAME varchar2(40) null, AD_TABLE_NAME varchar2(40) null, AD_ACTION_KIND varchar2(1) null, AD_IS_COLUMNS varchar2(1) null );
CREATE INDEX ACT_DEPEND_AD_ACTIONNAME ON ACT_DEPEND ( AD_ACTION_NAME );
CREATE VIEW EXECUTION_V AS SELECT * FROM TESTCYCL, TEST WHERE TC_TEST_ID = TS_TEST_ID;
Attached is a text file with all the SQL statements that create all tables, indexes and views for TestDirector 7.2.
Also attached is a Word document for TestDirector 7.5.
Note:
Creating these tables is not sufficient to bring up TestDirector and login to the project, since there is an initialization and customization data that must be added for these tables : system_field, all_lists, actions, etc.
When TestDirector 7.6 (7.5) creates an Oracle project, it first creates a user ("DomainName_ProjectName_db") and logs in as that user to create the Oracle database. That user is the owner of all the objects (tables and indexes) for the project.
Attachment : CPT7094.txt
Attachment : CreatingOracle75Project.doc