you can try using package
dbms_obfuscation_toolkit.desencrypt...
This will encrypt and decrypt data for you...
the only problem is if someone knows how to
run this package to decrypt the data he can
have access to passwords...
well you can have a look.
Let me know if someone have any better way
securing passwds after encrypting it.
Thanks.
- John Dunn <john.dunn_at_sefas.co.uk> wrote:
> Our development team want to control access to
> application functionality via
> 'logical' users. That is, a list of users and the
> application functions they
> can use will be maintained in a database table.
> Actual connection to the
> database would always be via one user(maybe the
> schema owner, maybe some
> other single specified user).
>
> Does anyone else have applications that work in this
> way? What use do you
> use to connect to the database?
>
> The 'logical' users would also have passwords that
> would need to be held on
> the database tables. Is there any (easy) way to
> encrypt a character string
> and store it on the database?
>
> The front end application is Visual Basic using
> OO4O...but we use lots of
> PL/SQL too.
>
> Database is Oracle 8.0.5
>
> John
>
>
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Ashish
Toronto, Canada
Do You Yahoo!?
Yahoo! Mail – Free email you can access from anywhere!
Received on Tue Aug 15 2000 - 09:10:44 CDT