When i try to use this function
create or replace function get_hash(
p_username in varchar2,
p_password in varchar2)
return varchar2
as
l_salt varchar2(30):= 'customerSalt';
begin
return dbms_crypto.hash(utl_raw.cast_to_raw(upper(p_username) || l_salt || upper(p_password)),dbms_crypto.hash_sh1);
end;
It says i need to declare DBMS_CRYPTO, i searched on the internet ,they said live sql does have this “crypto” but the user did't have permission for that, and i need to grant permission to the user that i currently using. But i don't how to grant the permission to the user in live sql