Env. 19c SE2
We are getting an ORA-00904 when trying to execute:
select dbms_sqlhash.gethash(sqltext => 'select * from emp',
digest_type => 4) as hash
from dual;
grant execute on dbms_sqlhash to user1; returns ORA-00942: table or view does not exist
Has to be granted by sys? ← Yes, sys has to grant the privilege.