Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to make DBA cannot 'see' User's Tables?

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

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Thu, 17 May 2001 04:32:48 -0700
Message-ID: <F001.00305F98.20010517035112@fatcity.com>

I think they may have changed that last year, didn't the Clinton Administration approve a bill re this?

Patrice Boivin
Systems Analyst (Oracle Certified DBA)

        -----Original Message-----
        From:   A. Bardeen [SMTP:abardeen1_at_yahoo.com]
        Sent:   Thursday, May 17, 2001 12:06 AM
        To:     Multiple recipients of list ORACLE-L
        Subject:        RE: How to make DBA cannot 'see' User's Tables?

        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

        --- 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: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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 - 06:32:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US