You Asked
With Always Free, there is no support. How do I get DBMS_CRYPTO grant? I tried using STANDARD_HASH, but it says STANDARD_HASH must be declared. So is there a way to get this access preferably to DBMS_CRYPTO? If not is there an alternative?
and Connor said...
They both work for me on my free instance
SQL*Plus: Release 23.0.0.0.0 - Production on Tue Dec 2 13:40:00 2025
Version 23.9.0.25.07
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Last Successful login time: Tue Dec 02 2025 01:02:20 +08:00
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.0.1.0 - for Oracle Cloud and Engineered Systems
Version 23.26.0.1.0
SQL> select standard_hash('qweqwe');
STANDARD_HASH('QWEQWE')
----------------------------------------
F4542DB9BA30F7958AE42C113DD87AD21FB2EDDB
SQL> select dbms_crypto.randomnumber;
RANDOMNUMBER
------------
1.1654E+38