Implement Roles: tools/experience of table search in form/report
Date: 6 Feb 1995 20:57:21 GMT
Message-ID: <3h62fh$vl_at_news.tamu.edu>
Hello everyone,
We here at TEES Computing services, Texas A&M university, are running Banner Finance on Oracle 7.0.13.1. We are in the process of converting our security to using roles. To do this, the biggest task is to look at hundreds of forms and reports to find out what tables are being accessed, in order to implement roles.
We are trying to use an RPT known as XREF which has the ability to search through a form (if saved in database), based on some conditions and give a listing of all the tables accessed by that form.
I was wondering if someone else has any similar program which would go through an SQL*Reportwriter report or SQL script report or through an RPT report and give a listing of all the tables accessed by a report.
Any other pointers, examples, previous/similar experience in this type of implementation of roles would be greatly appreciated.
Murali
Systems Analyst/DBA
TEES Computing Services
College Station, TX
email: rajasaheb_at_tamu.edu
(409) 862-1526
Received on Mon Feb 06 1995 - 21:57:21 CET