Re: Read Only Login with Source Visibility

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.
Dale_at_DataBee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Dale_at_DataBee.com

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: ListGuru_at_fatcity.com (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).