Re: Is is possible to do this in Oracle?

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
>
>
jimmy,
There is wrapper utility you can use to hide your souce code. Ted

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 13 1999 - 19:57:20 CEST