Can anyone provide me with a way to restrict a report writer's view of the Oracle database data. A Crystal Report developer should be able to view 'only' the data specific to the department they are in - not any other department's data. This may be possible by creating a separate view of the data for each dept but I'm hoping to find a less burdensome and more sophisticated solution.
Thanks for your help,
Janice