Remote DBA Plans
Remote DBA Service

EnterpriseDB: Oracle Traker Grants Synonyms

Oracle Tips by Burleson Consulting

CREATE PUBLIC SYNONYM TT_SCHEDULES FOR traker.TT_SCHEDULES;
CREATE PUBLIC SYNONYM TT_XML_INTERFACE FOR traker.TT_XML_INTERFACE;
CREATE PUBLIC SYNONYM TT_TASKS FOR traker.TT_TASKS;
CREATE PUBLIC SYNONYM TT_PROJECTS FOR traker.TT_PROJECTS;
CREATE PUBLIC SYNONYM TT_RESOURCES FOR traker.TT_RESOURCES;
CREATE PUBLIC SYNONYM TT_PROJECTS_TASKS FOR traker.TT_PROJECTS_TASKS;
CREATE PUBLIC SYNONYM TT_TASKS_RESOURCES FOR traker.TT_TASKS_RESOURCES;
CREATE PUBLIC SYNONYM TT_TASK_ITEM_UPDATE FOR traker.TT_TASK_ITEM_UPDATE;
CREATE PUBLIC SYNONYM TT_TASK_DEPENDS FOR traker.TT_TASK_DEPENDS;
CREATE PUBLIC SYNONYM tt_general_Sequence FOR traker.tt_general_Sequence;
CREATE PUBLIC SYNONYM TT_MANAGE_USER_RECORDS FOR traker.TT_MANAGE_USER_RECORDS;
CREATE PUBLIC SYNONYM TT_REPORT_OUTPUT FOR traker.TT_REPORT_OUTPUT;
CREATE PUBLIC SYNONYM TT_CALENDAR_ADMIN FOR traker.TT_CALENDAR_ADMIN;
CREATE PUBLIC SYNONYM TT_MANAGE_RESOURCES FOR traker.TT_MANAGE_RESOURCES;
CREATE PUBLIC SYNONYM TT_MANAGE_PROJECTS FOR traker.TT_MANAGE_PROJECTS;
CREATE PUBLIC SYNONYM TT_USER_ADMIN FOR traker.TT_USER_ADMIN;
GRANT execute on tt_security_levels TO tt_admin_role;
GRANT select, insert, update, delete ON TT_SECURITY_LEVELS TO tt_admin_role;
GRANT select, insert, update, delete ON TT_SCHEDULES TO tt_admin_role;
GRANT select, insert, update, delete ON TT_XML_INTERFACE TO tt_admin_role;
GRANT select, insert, update, delete ON TT_TASKS TO tt_admin_role;
GRANT select, insert, update, delete ON TT_PROJECTS TO tt_admin_role;
GRANT select, insert, update, delete ON TT_CALENDAR TO tt_admin_role;
GRANT select, insert, update, delete ON TT_RESOURCES TO tt_admin_role;
GRANT select, insert, update, delete ON TT_PROJECTS_TASKS TO tt_admin_role;
GRANT select, insert, update, delete ON TT_TASKS_RESOURCES TO tt_admin_role;
GRANT select, insert, update, delete ON TT_TASK_ITEM_UPDATE TO tt_admin_role;
GRANT select, insert, update, delete ON TT_TASK_DEPENDS TO tt_admin_role;

GRANT select, insert, update, delete ON TT_REPORTS TO tt_admin_role;
GRANT execute on TT_MANAGE_USER_RECORDS TO tt_admin_role;
GRANT execute on TT_MANAGE_USER_RECORDS TO tt_user_role;
GRANT execute on TT_MANAGE_USER_RECORDS TO tt_pm_role;
GRANT execute on TT_REPORT_OUTPUT TO tt_admin_role;
GRANT execute on TT_CALENDAR_ADMIN TO tt_admin_role;
GRANT execute on TT_MANAGE_RESOURCES TO tt_admin_role;
GRANT execute on TT_MANAGE_PROJECTS TO tt_admin_role;
GRANT execute on TT_MANAGE_RESOURCES TO tt_pm_role;
GRANT execute on TT_MANAGE_PROJECTS TO tt_pm_role;
GRANT execute on TT_USER_ADMIN TO tt_admin_role;
GRANT execute on TT_REPORT_OUTPUT TO public;

* chap9_oracle_traker_sample_data.sql

BEGIN

tt_calendar_admin.populate_calendar;
tt_calendar_admin.change_holiday_flag(to_date('25-DEC-2007', 'DD-MON-YYYY'));

tt_calendar_admin.schedule('mon-fri', 'N', NULL, NULL, NULL,
                                                 NULL, NULL, 'N');
tt_calendar_admin.schedule('mon-fri', 'Y', NULL, 'N', NULL,
                                                 NULL, NULL, NULL);

tt_manage_resources.add_resource('Lewis Cunningham', 'mon-fri', 80, 8, 'Programmer', 'Y',
'Lewis Cunningham', 'Y');
tt_manage_resources.add_resource('Billy Bob', 'mon-fri', 10, 2, 'User', 'Y', 'BBob', 'Y');
tt_manage_resources.add_resource('Alex Trebec', 'mon-fri', 90, 8, 'Proud Canadian', 'Y',
'Say What', 'Y');
tt_manage_resources.add_resource('Wink Martindale', 'mon-fri', 950, 8, 'Game Show Host',
'Y', 'WinkWink', 'Y');
tt_manage_resources.add_resource('Kerplunkita Goboom', 'mon-fri', 3, 1, 'Remote DBA', 'Y',
'NoSpaceForJue', 'Y');
tt_manage_resources.add_resource('Nodvery Bright', 'mon-fri', 120, 12, 'PM', 'Y', 'Que',
'Y');

tt_manage_projects.create_tasks('Task1', 'The First Task', 'Y');
tt_manage_projects.create_tasks('Task2', 'The Second Task', 'Y');
tt_manage_projects.create_tasks('Task3', 'The Third Task', 'Y');
tt_manage_projects.create_tasks('Task4', 'The Fourth Task', 'Y');

tt_manage_projects.create_project('Project1', 'The first project', 'Y');
tt_manage_projects.create_project('Project2', 'The Second project', 'Y');
tt_manage_projects.create_project('Project3', 'The Third project', 'Y');

tt_manage_projects.assign_resource_to_task('Task1', 'Lewis Cunningham');
tt_manage_projects.assign_resource_to_task('Task2', 'Lewis Cunningham');
tt_manage_projects.assign_resource_to_task('Task3', 'Lewis Cunningham');

tt_manage_projects.assign_resource_to_task('Task2', 'Kerplunkita Goboom');
tt_manage_projects.assign_resource_to_task('Task3', 'Kerplunkita Goboom');

tt_manage_projects.assign_resource_to_task('Task3', 'Nodvery Bright');
tt_manage_projects.assign_resource_to_task('Task4', 'Nodvery Bright');

tt_manage_projects.assign_task_to_project('Task1', 'Project1', 5, 50, 'Project1 - Task1');
tt_manage_projects.assign_task_to_project('Task2', 'Project1', 5, 50, 'Project1 - Task2');
tt_manage_projects.assign_task_to_project('Task2', 'Project2', 5, 50, 'Project2 - Task2');
tt_manage_projects.assign_task_to_project('Task3', 'Project2', 5, 50, 'Project2 - Task3');
tt_manage_projects.assign_task_to_project('Task4', 'Project3', 5, 50, 'Project3 - Task4');

tt_manage_projects.create_item_dependancies('Project1', 'Task1', 'Task2', 'Project1');
tt_manage_projects.create_item_dependancies('Project3', 'Task4', 'Task2', 'Project1');

tt_manage_user_records.add_xml_record('<?xml version="1.0"?>
        <interface>
            <who>Lewis Cunningham</who>
            <what>Task1</what>
            <when>02-JAN-2007</when>
            <hours>8</hours>
        </interface>');

COMMIT;
END;