| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to make DBA cannot 'see' User's Tables?
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).
-- 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).Received on Thu May 17 2001 - 08:49:10 CDT
 |
 |