Neco jako MySql.PASSWORD() v Oracle9?
Vitezslav Skacel
skacel na cis.vutbr.cz
Čtvrtek Prosinec 12 10:08:33 CET 2002
Michal Dobes wrote:
> Zdravim,
>
> je v Oracle nejaka funkce vhodna k ukladani a overovani hesel
> do tabulek, at hned kazdy nevidi co nema? Nechce se mi strkat hesla
> zvlast do dalsi tabulky a zpristupnovat je jen pro opravnene.
>
> Majkl
Nebo jeste lepsi je
SYS.Package.DBMS_OBFUSCATION_TOOLKIT
AS
------------------------------- TYPES
------------------------------------
-- Types used to make it easier for the user to reserve the correct
-- amount of memory for a checksum.
SUBTYPE varchar2_checksum IS VARCHAR2(16);
SUBTYPE raw_checksum IS RAW(16);
----------------------------- CONSTANTS
-----------------------------------
-- Triple DES modes
TwoKeyMode INTEGER := 0;
ThreeKeyMode INTEGER := 1;
---------------------- FUNCTIONS AND PROCEDURES
---------------------------
---------------------------- DATA ENCRYPTION
------------------------------
-- The following routines encrypt and decrypt data.
-- There are two versions of each procedure and function: one for
raw data
-- and the other for strings.
---------------------------------------------------------------------------
-- DES
PROCEDURE DESEncrypt(input IN RAW,
key IN RAW,
encrypted_data OUT RAW);
FUNCTION DESEncrypt(input IN RAW,
key IN RAW)
RETURN RAW;
PROCEDURE DESEncrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2,
encrypted_string OUT VARCHAR2);
FUNCTION DESEncrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2)
RETURN VARCHAR2;
PROCEDURE DESDecrypt(input IN RAW,
key IN RAW,
decrypted_data OUT RAW);
FUNCTION DESDecrypt(input IN RAW,
key IN RAW)
RETURN RAW;
PROCEDURE DESDecrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2,
decrypted_string OUT VARCHAR2);
FUNCTION DESDecrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2)
RETURN VARCHAR2;
-- Triple DES
PROCEDURE DES3Encrypt(input IN RAW,
key IN RAW,
encrypted_data OUT RAW,
which IN PLS_INTEGER
DEFAULT TwoKeyMode);
FUNCTION DES3Encrypt(input IN RAW,
key IN RAW,
which IN PLS_INTEGER DEFAULT TwoKeyMode)
RETURN RAW;
PROCEDURE DES3Encrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2,
encrypted_string OUT VARCHAR2,
which IN PLS_INTEGER
DEFAULT TwoKeyMode);
FUNCTION DES3Encrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2,
which IN PLS_INTEGER DEFAULT TwoKeyMode)
RETURN VARCHAR2;
PROCEDURE DES3Decrypt(input IN RAW,
key IN RAW,
decrypted_data OUT RAW,
which IN PLS_INTEGER
DEFAULT TwoKeyMode);
FUNCTION DES3Decrypt(input IN RAW,
key IN RAW,
which IN PLS_INTEGER DEFAULT TwoKeyMode)
RETURN RAW;
PROCEDURE DES3Decrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2,
decrypted_string OUT VARCHAR2,
which IN PLS_INTEGER
DEFAULT TwoKeyMode);
FUNCTION DES3Decrypt(input_string IN VARCHAR2,
key_string IN VARCHAR2,
which IN PLS_INTEGER DEFAULT TwoKeyMode)
RETURN VARCHAR2;
-------------------------------- MD5
--------------------------------------
-- The following routines generate MD5 hashes of data.
-- There are two versions: one for raw data and the other for strings.
---------------------------------------------------------------------------
PROCEDURE MD5(input IN RAW,
checksum OUT raw_checksum);
FUNCTION MD5(input IN RAW)
RETURN raw_checksum;
PROCEDURE MD5(input_string IN VARCHAR2,
checksum_string OUT varchar2_checksum);
FUNCTION MD5(input_string IN VARCHAR2)
RETURN varchar2_checksum;
END dbms_obfuscation_toolkit;
Další informace o konferenci Databases