Re: How to make DBA cannot 'see' User's Tables?

oops!

My previous post said that the key must be on 8 byte boundaries.

That is incorrect. I believe the data must be on 8 byte boundaries.

Guess I should re-read my own article.

Jared

On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho 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).

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).