Doh! I knew there was something else I was forgetting
(shows you how many times I've used it). Thanks Paul
and Rachel and Jared!
- Anita
- Rachel Carmichael <carmichr_at_hotmail.com> wrote:
> to carry this forward (hey Paul and Anita!)
>
> you can also look at:
>
>
http://www.cybcon.com/~jkstill/util/encryption/encryption.html
>
> Jared's site with some VERY easy to understand
> explanations on how to use
> encryption
>
> and yes the string length has to be a multiple of 8
> characters
>
> Rachel
>
> >From: Paul Drake <paled_at_home.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> >Subject: Re: How to make DBA cannot 'see' User's
> Tables?
> >Date: Wed, 16 May 2001 21:56:01 -0800
> >
> >"A. Bardeen" wrote:
> > >
> > > You can encrypt using only a 56-bit key (the key
> > > length limitation is a requirement of US
> regulations
> > > governing the export of cryptographic products).
> > >
> > > HTH,
> > >
> > > -- Anita
> >
> >Hi Anita.
> >
> >
> >Ahmadsyah,
> >
> >I believe that you also have to pad the string to a
> length that is a
> >multiple of 8 characters.
> >Your key string was 10 characters.
> >
> >here's the obligatory link to the fine manual:
> (that includes a code
> >example)
>
>http://technet.oracle.com/doc/oracle8i_816/server.816/a76936/dbms_obf.htm#6518
> >
> >Paul
> >
> >
> > >
> > > --- Ahmadsyah Algozhi Nugroho
> <aan_at_nwa.iao.co.id>
> > > wrote:
> > > > I'm using Oracle 8.1.7.
> > > > there was an error
> > > > ERROR at line 1:
> > > > ORA-28232: invalid input length for
> obfuscation
> > > > toolkit
> > > > ORA-06512: at
> "SYS.DBMS_OBFUSCATION_TOOLKIT_FFI",
> > > > line 0
> > > > ORA-06512: at "SYS.DBMS_OBFUSCATION_TOOLKIT",
> line
> > > > 33
> > > > ORA-06512: at "SCOTT.IAO_PROTECT", line 15
> > > > ORA-06512: at line 1
> > > >
> > > > I check thath my key and my input string is
> > > > varchar12(10).
> > > > Key = 0123456789
> > > > input string = 'testtestte'
> > > >
> > > > dbms_obfuscation_toolkit.desencrypt (
> > > > input_string => 'testtestte'
> > > > , key_string => '1234567890'
> > > > , encrypted_string => vEncrypted
> > > > );
> > > > Am I forget something?
> > > >
> > > > TIA,
> > > >
> > > >
> > > > Ahmadsyah Alghozi Nugroho
> > > > Database Engineering Specialist
> > > > PT Infoglobal AutOptima
> > > > Jl. Baruk Tengah I/49
> > > > Surabaya - Jawa Timur
> > > > phone : +62 (31) 8708456 ext.113
> > > > > From: Srinagesh Battula
> > > > [mailto:sbattula_at_vcommerce.com]
> > > > > Sent: Thursday, May 17, 2001 7:26 AM
> > > > > To: Multiple recipients of list ORACLE-L
> > > > > Subject: RE: How to make DBA cannot 'see'
> User's
> > > > Tables?
> > > > >
> > > > >
> > > > >
> > > > > You can encrypt & Decrypt data using the
> > > > > DBMS_OBFUSCATION_TOOLKIT package
> > > > > (comes with 8.1.6)
> > > > >
> > > > > Srinagesh "What do I know any way" Battula
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Khedr, Waleed
> > > > [mailto:Waleed.Khedr_at_FMR.COM]
> > > > > > Sent: Wednesday, May 16, 2001 4:21 PM
> > > > > > To: Multiple recipients of list ORACLE-L
> > > > > > Subject: RE: How to make DBA cannot 'see'
> User's
> > > > Tables?
> > > > > >
> > > > > >
> > > > > > Data Encryption?
> > > > > >
> > > > > > -----Original Message-----
> > > > > > Sent: Wednesday, May 16, 2001 7:01 PM
> > > > > > To: Multiple recipients of list ORACLE-L
> > > > > >
> > > > > >
> > > > > >
> > > > > > Dear gurus,
> > > > > > How to make DBA cannot 'see' user's datas?
> > > > > > I build an application which very
> important and
> > > > top secret
> > > > > > even DBA cannot
> > > > > > 'see' this data. But DBA can backup this
> > > > data.What is the
> > > > > > solution for this
> > > > > > problem?
> > > > > >
> > > > > > TIA,
> > > > > >
> > > > > >
> > > > > > Ahmadsyah Alghozi Nugroho
> > > > > > Database Engineering Specialist
> > > > > > PT Infoglobal AutOptima
> > > > > > Jl. Baruk Tengah I/49
> > > > > > Surabaya - Jawa Timur
> > > > > > phone : +62 (31) 8708456 ext.113
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > > --
> > > > > > Author: Khedr, Waleed
> > > > > > INET: Waleed.Khedr_at_FMR.COM
> > > > > >
> > > > > > 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).
> > > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > > --
> > > > > Author: Srinagesh Battula
> > > > > INET: sbattula_at_vcommerce.com
> > > > >
> > > > > 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).
> > > > >
> > > >
> > >
> > >
> __________________________________________________
> > > Do You Yahoo!?
> > > Yahoo! Auctions - buy the things you want at
> great prices
> > > http://auctions.yahoo.com/
> > > --
> > > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > > --
> > > Author: A. Bardeen
> > > INET: abardeen1_at_yahoo.com
> > >
> > > 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).
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Paul Drake
> > INET: paled_at_home.com
> >
> >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).
>
>
> Get your FREE download of MSN Explorer at
> http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: carmichr_at_hotmail.com
>
> 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).
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
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).
Received on Thu May 17 2001 - 20:25:45 CDT
