We are running Oracle 9i on Windows 2003 Server in our company and we have lots of forms and reports already.
Now, the company is dividing into five separate sections and we want the users in each section only to access the data about their own section. Also the complete data can be accessed in one place for monitoring.
In our tables, there is no field that determines the section. How can we do that with little cost and time and without having to change the source code of all applications (forms and reports)? The workflow in each section is the same. Can we use partitioning or replication or database cloning? Which one is better?
Please help. Thank you so much.
This was first published in February 2007