 |
|
EnterpriseDB: Traker Grants Synonyms
Oracle Tips by Burleson Consulting
|
*
chap9_edb_traker_grants_synonyms.sql
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 execute on package TT_MANAGE_USER_RECORDS TO tt_admin_role;
GRANT execute on package TT_MANAGE_USER_RECORDS TO tt_user_role;
GRANT execute on package TT_MANAGE_USER_RECORDS TO tt_pm_role;
GRANT execute on package TT_REPORT_OUTPUT TO tt_admin_role;
GRANT execute on package TT_CALENDAR_ADMIN TO tt_admin_role;
GRANT execute on package TT_MANAGE_RESOURCES TO tt_admin_role;
GRANT execute on package TT_MANAGE_PROJECTS TO tt_admin_role;
GRANT execute on package TT_MANAGE_RESOURCES TO tt_pm_role;
GRANT execute on package TT_MANAGE_PROJECTS TO tt_pm_role;
GRANT execute on package TT_USER_ADMIN TO tt_admin_role;
GRANT execute on package TT_REPORT_OUTPUT TO public;
*
chap9_edb_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', p_sunday =>
'N', p_saturday => 'N');
tt_calendar_admin.schedule('mon-fri', p_sunday => 'Y', p_tuesday =>
'N');
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',
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;
Conclusion
This
chapter was not intended to scare you away from migrating an
application. It was intended to show you that even a small, fairly
simple application will require some analysis and thought before
beginning. Only you can decide if the effort is worthwhile.
If
this chapter did scare you off, then I am glad. That means you had
not given enough thought to the process and may have been
unsuccessful or over budget because of that.
However, having said all of that, if you do put a little forethought
into migrating your applications, it is not brain surgery.
EnterpriseDB Advanced Server makes it about as simple as it is
possible to make it. A migration from Oracle would certainly not be
any easier for any other database and I would have to say that it
would be much more complex.
I have
heard percentages bandied about that EnterpriseDB will convert XX%
without changes. The only percentage that matters is the percentage
of your applications that it will convert without changes. You
won't know that until you put some analysis into it.
I have
also heard that because EnterpriseDB doesn't support YY feature, you
cannot, or should not, migrate your application. I hope that I have
shown you that there is more than one way to any answer and if
EnterpriseDB does not support something for you out of the box,
there are usually tools available that will support your need.
This
is the end of the book. I covered a lot of material in just a few
chapters. EnterpriseDB is a superior database and by adding Oracle
compatibility at a reasonable price, I think it makes a place for
itself in every enterprise.
This
is an excerpt from the book "EnterpriseDB:
The Definitive Reference" by Rampant TechPress.
