RE: How to make DBA cannot 'see' User's Tables?
Similarly the input text length needs to be a multiple of 8 - a sample of how to do this is on my site somewhere (see sig) hth connor --- A. Bardeen [EMAIL PROTECTED] 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 --- Ahmadsyah Algozhi Nugroho [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue
RE: How to make DBA cannot 'see' User's Tables?
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:[EMAIL PROTECTED]] 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE
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 [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL
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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to make DBA cannot 'see' User's Tables?
The key must be on 8 byte boundaries. See my article on encryption at www.cybcon.com/~jkstill/util 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to make DBA cannot 'see' User's Tables?
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to make DBA cannot 'see' User's Tables?
If its a stored procedure i know that you can use a oracle tool called warp ( or wrap?) to encrypt the code. Its a comand line utility. Rajaram. -Original Message- From: Ahmadsyah Algozhi Nugroho [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Subject:How to make DBA cannot 'see' User's Tables? 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 File: ATT2.html NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to make DBA cannot 'see' User's Tables?
Title: RE: How to make DBA cannot 'see' User's Tables? 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: How to make DBA cannot 'see' User's Tables?
Encryption. In 8i release 2 there is the package DBMS_OBFUSCATION_TOOLKIT. Before that you are on your own. Djordje -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/16/01 7:00 PM 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: Djordje Jankovic INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to make DBA cannot 'see' User's Tables?
Yes ! Use wrap utility to hide the code from your DBA(even from you). WRAP INAME=SRCFILE.SQL output file name will be SRCFILE.PLB This is a command line utility. But do not forget to keep to the original SQL file with you. HTH Naba J Neog - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 17, 2001 5:50 AM If its a stored procedure i know that you can use a oracle tool called warp ( or wrap?) to encrypt the code. Its a comand line utility. Rajaram. -Original Message- From: Ahmadsyah Algozhi Nugroho [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 7:01 PM To: Multiple recipients of list ORACLE-L Subject: How to make DBA cannot 'see' User's Tables? 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 File: ATT2.html NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: N J Neog INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: How to make DBA cannot 'see' User's Tables?
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 [EMAIL PROTECTED] 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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED