dbms_crypto
replaces dbms_obfuscation_toolkit
. dbms_crypto
, the user must be granted execution on the package, otherwise, the error PLS-00201: identifier 'DBMS_CRYPTO' must be declared is thrown. grant execute on dbms_crypto to rene;
select distinct procedure_name from all_procedures where object_name = 'DBMS_CRYPTO' order by procedure_name
DECRYPT | |
ENCRYPT | |
HASH | Creates a hash value from a raw , blob or clob . |
MAC | |
PKDECRYPT | |
PKENCRYPT | |
RANDOMBYTES | Retrns a cryptographically secure pseudo-random sequence of bytes, based on RSA X9.31 PRNG algorithm. Compare with dbms_random which is not cryptographically secure. |
RANDOMINTEGER | Returns a random integral number in the range of the binary_integer data type. |
RANDOMNUMBER | Returns a random integral number as number data type. |
SIGN | |
VERIFY |