Hi Bill > I am trying to create a read-only login, RO_USER which can do the following: > 1. See all tables, views, constraints etc. in one *specific* other schema, > 2. See all the source for PL/SQL objects in APP.
Is what you really want is a way for users to be able to see the DDL and PL/SQL without actually being able to run or modify it? If so, as a suggestion, why don't you try using the DDL to HTML documentation generator in the freeware DBATool. You could easily cut a browsable tree with all (or part) of a schemas DDL. It also does nice things like cross reference related entities - for example for a table you can click on links to the associated indexes, foreign keys, grants, synonyms etc. Password protection and security can easily be implemented by moving the HTML tree onto a password protected drive. An example tree can be found at the link below http://www.databee.com/dt_htmltree/db=TESTDB1+sc=DT_TEST.htm The DBATool is freeware http://www.DataBee.com Regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
