Re: Is is possible to do this in Oracle?

For the second question...
There is a utility called wrap which will convert your source code into an intermediate form of object code. You can then install that code into the database. This will prevent anybody from being able to pull the source code from dba_source. ( Check some of the packages created by Oracle like dbms_irefresh.).

You can find more information about this in PL/SQL Guide Appendix.

Shelby
In article <37B3C8CE.4F7940B8_at_comp.polyu.edu.hk>,   Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:
> Hello all,
>
> I wonder whether the below requirements can be implemented in
Oracle
> 7.3.3. (or higher)
>
> 1) Is it possible to specify the data type (and width) of the column
in
> a view? I try "create view aaa (aaa number(22,6)) as select bbb from
> bbb" but failed.
>
> 2) I developed triggers and PL/SQL procedures and functions in Oracle
> 7.3.3. I don't want to let other developers to read the PL/SQL coding
> (triggers, procedures and functions). Is it possible to "hide" this
> coding even the developers have privileges to query the dba_source
view?
> (for example, is it possible to set up the password?)
>
> Thanks,
> Jimmy
>
>

Sent via Deja.com http://www.deja.com/
[Quoted] Share what you know. Learn what you don't. Received on Fri Aug 13 1999 - 20:42:07 CEST