Re: Need help with V$PARAMETER

Valodia,

How can I encrypt and decrypt data in Oracle? I am storing user PINs in a table (not in DBA_USER). I need to encrypt them. Is there any Oracle DBMS utlity that I could use for it. Can you or any one else provide me with an example or reference where I could read about it.

Thanks.

Aziz

"Vladimir M. Zakharychev" <bob_at_dpsp-yes.com> wrote in message news:amnhpm$a3k$1_at_babylon.agtel.net...
> > I tried the DBMS_UTILITY.GET_PARAMETER_VALUE and it worked perfectly.
> > I think I can not access V_$PARAMETER for some security reason
implemented
> > in our development environment.
>
> That's great, but just so that the question will not reappear any time
soon
> with different database object, take heed to those who said that you had
to
> grant SELECT *directly* to the *user* owning your procedure - stored
> procedures do NOT inherit privileges from roles, NO roles are active when
> stored procedure is compiled or executed (unless it's authid current_user
> in 8i+.)
>
> --
> Vladimir Zakharychev (bob_at_dpsp-yes.com)
http://www.dpsp-yes.com
> Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet
applications.
> All opinions are mine and do not necessarily go in line with those of my
employer.
>
>
Received on Tue Sep 24 2002 - 22:32:54 CDT