Stack Overflow
Stack Overflow

Questions tagged [dbms-crypto]

DBMS_CRYPTO provides an interface to encrypt and decrypt stored data, and can be used in conjunction with PL/SQL programs running network communications.

DBMS_CRYPTO provides an interface to encrypt and decrypt stored data, and can be used in conjunction with PL/SQL programs running network communications.

See http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_crypto.htm

31 questions
6
votes
1 answer

grant permission for dbms_crypto

I am using dbms_crypto.encrypt function in my oracle procedure for encryption of passwords. I have connected to oracle as : connect sqlplus as sysdba and then granted permission as : grant execute on sys.dbms_crypto to myuser; And then i can use…
Andrew
  • 3,632
  • 24
  • 64
  • 113
4
votes
1 answer

What is the DBMS_Crypto.encrypt() equivalent of DBMS_Obfuscation_Toolkit.DES3Encrypt()?

I am editing some Oracle code that includes DBMS_Obfuscation_Toolkit references. I read that the DBMS_Obfuscation_Toolkit package is de-supported as of Oracle 10.2, and that I should upgrade my code to instead be use DMBS_Crypto. I have this…
Jeromy French
  • 11,812
  • 19
  • 76
  • 129
3
votes
1 answer

DBMS_CRYPTO package is missing

I am using Oracle Database 11g Enterprise Edition Release 11.2.00.40 - 64bit Production. We have a initial admin user which will be created in a database by inserting into a table during the installation. This action requires to encrypt password…
Sanja
  • 397
  • 2
  • 7
  • 24
2
votes
0 answers

Migrate dbms_crypto encrypted data from oracle to PostgreSQL

I want to migrate some of the tables with encrypted columns from oracle to postgres. In oracle, data is encrypted uding dbms_crypto. I am thinking that I will encrypt data in postgreSQL using pgp keys. My question is - 1. Do I need to decrypt the…
megha jain
  • 21
  • 3
2
votes
0 answers

SYS.DBMS_CRYPTO error while decrypting the encrypted password

I have the below function in package where i am trying to decrpyt the encrypted password but getting the below error message: ORA-28817: PL/SQL function returned an error. ORA-06512: at "SYS.DBMS_CRYPTO_FFI", ORA-06512: at "SYS.DBMS_CRYPTO",…
Andrew
  • 3,632
  • 24
  • 64
  • 113
2
votes
3 answers

Can the Oracle PL/SQL dbms_crypto package decrypt a file encrypted with the Linux gpg command?

I'm new to encryption and am trying to figure out if the Linux gpg command and Oracle's dbms_crypto package can work together. Oracle version is 11R2. I'll be receiving files encrypted by a different system and would like to decrypt them via…
John
  • 111
  • 1
  • 2
  • 8
1
vote
1 answer

How to connect DBMS_CRYPTO?

Im trying to use DBMS_CRYPTO. From SYSTEM write: DECLARE l_key VARCHAR2 (2000) := '1234567890123456'; l_in_val VARCHAR2 (2000) := 'Confidential Data'; l_mod NUMBER := DBMS_CRYPTO.encrypt_aes128 …
Sova Kefirova
  • 201
  • 1
  • 9
1
vote
0 answers

dbms_crypto and CryptoJS.HmacSHA256 returns different output

the javascript version and plsql code doesnt return the same output. Javascript code: var hash = CryptoJS.HmacSHA256(StringToSign,l_secret_key); var hashutf8 = CryptoJS.enc.Utf8.parse(hash); var hashInBase64 =…
Rashmi64
  • 11
  • 1
1
vote
1 answer

Column Value is Hashed or not

How to identify that a column in oracle is encrypted using DBMS_CRYPTO.HASH or DBMS_OBFUSCATION_TOOLKIT.MD5 or not Table with HASH Value Is there any function that i can run across all columns of the oracle database (ALL_TAB_COLUMNS) which will…
Rajib Saha
  • 11
  • 2
1
vote
1 answer

Cannot Decrypt Varchar2 password using DBMS_CRYPTO.DECRYPT

what i need i need to decrypt password store in database. I tried sql https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_crypto.htm#i1001225 sql DECLARE input_string VARCHAR2 (200) := 'Secret…
afeef
  • 4,396
  • 11
  • 35
  • 65
1
vote
0 answers

Is DBMS_CRYPTO.DECRYPT with salt possible?

Is there a way to set the salt in pl/sql when using DBMS_CRYPTO? My code looks like: --PBEWithMD5AndTripleDES -> Origin Encryption algorithm encryption_type PLS_INTEGER := SYS.DBMS_CRYPTO.DES3_CBC_PKCS5 + DBMS_CRYPTO.HASH_MD5; saltInput…
Pwnstar
  • 2,333
  • 2
  • 29
  • 52
1
vote
1 answer

DBMS_CRYPTO.RANDOMBYTES returns null

This statement returns null instead of 64 random bytes: select DBMS_CRYPTO.RANDOMBYTES(64) from dual; What is causing it to return null? Database is Oracle 10.1.0.2.0 running on Windows Server 2003 and I want to use the random bytes as salt for…
johanrex
  • 389
  • 5
  • 18
1
vote
1 answer

Encrypt string with PLSQL then decrypt with PHP

I have an application where I'm trying to encrypt a string using PLSQL (dbms_crypto.encrypt), save it to a cookie, then read the cookie using PHP (mcrypt_decrypt) and decrypt the string. I'm having a heck of a time getting the string to decrypt. …
Fotan
  • 13
  • 5
1
vote
2 answers

Select DBMS_CRYPTO password hashes in Oracle 11g

I am currently hashing my password field in my Oracle database by using DBMS_CRYPTO.HASH. At this point, however, I need to allow my Java application to be able to authenticate a password on user input in a way similar to what MySQL does. Something…
Stanley Mungai
  • 4,044
  • 30
  • 100
  • 168
1
vote
1 answer

how to use Oracle's dbms crypto to create htpasswd compatible passwords

Is there any way to use Oracles DBMS_CRYPTO PL/SQL package to create passwords that are compatible with apache's htpasswd? So in a PL/SQL package I create a hashed password which when later stored in an .htpasswd file, will work fine. We…
user1505207
  • 13
  • 2
1
2 3