RE: Errors wile PL/SQL EXEC

From: KLOPPING, JEFFREY L <jklopping_at_oppd.com>
Date: Thu, 26 Oct 2000 14:07:51 -0500
Message-Id: <10661.120327@fatcity.com>

Check your default login.sql script...
also see below from metalink...

From: Oracle, Charles Blakey 18-Oct-00 16:22 Subject: Re : Encrypting a password field

Roy:

Oracle 8i Release2(8.1.6) provides enhanced security features. Among them is

the ability to encrypt data stored in the database. This means at the column

level such as encrypting chemical formulas, credit card numbers, passwords or
whatever data is sensitive to your business. Until now only Protegrity's 3rd

party product Secure.data had this capability. Oracle is now the only database
vendor in the world that provides this feature directly in the database and on
all platforms supporting 8.1.6. Protegrity supports only NT, HP-UX, Sun Solaris
and AIX.

How it works :

---

Oracle allows data to be encrypted and decrypted using the built in package DBMS_OBFUSCATION_TOOLKIT.
The package contains 4 procedures :
- 2 procedures that Encrypt VARCHAR2 and RAW data - 2 procedures that Decrypt VARCHAR2 and RAW data. To install the package :
1) connect as SYS and run dbmsobtk.sql and prvtobtk.plb 2) grant execute on dbms_obfuscation_toolkit to public

The functions accept 2 parameters : the data to encrypt or decrypt and the key
used for the encryption or decryption algorithm. A working example is shown below.

Limitations :

---

1)Data can only be encrypted using the DES(Data Encryption Standard)symmetric
key algorithm. When using symmetric key algorithms, once the data is encrypted
with a given key you cannot decrpyt without using the same key.

2)You can only encrypt using a 56-bit key. The key length limitation is a requirement of US regulations governing the export of cryptographic products.

3)You cannot double encrypt data meaning you cannot re-encrypt already encrpyted
data.

The current limitations will be improved in the next releases such as a bigger
choice of encryption algorithms and stronger Keys (128 bit). In any case, encrypting data inside the database should be part of a global security strategy that envolves access control such as using roles etc... You should also plan what to encrypt. Encrypting and decrypting entire tables
will increase CPU usage.

Regards...

Chuck

> -----Original Message-----
> From: MacGregor, Ian A. [SMTP:ian_at_SLAC.Stanford.EDU]
> Sent: Thursday, October 26, 2000 1:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Errors wile PL/SQL EXEC
>
> Perhaps you did not run $ORACLE_HOME/rdbms/admin/catobtk.sql?
>
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_slac.stanford.edu
>
> -----Original Message-----
> Sent: Thursday, October 26, 2000 8:16 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi guys,
>
> can anyone tell me why i am getting the error below.
> whenever i execute any pl/sql procedure.
>
> ORA-06550: line 24, column 7:
> PLS-00201: identifier 'SYS.DBMS_OBFUSCATION_TOOLKIT'
> must be declared
> ORA-06550: line 24, column 7:
> PL/SQL: Statement ignored
>
> Varma poosapati
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Messenger - Talk while you surf! It's FREE.
> http://im.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Poosapati Varma
> INET: psgkv_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: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> 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
Received on Thu Oct 26 2000 - 14:07:51 CDT