Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ORA-00904 ("SYS"."DBMS_SQLHASH"."GETHASH")

user545194Feb 12 2024 — edited Feb 12 2024

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.

Comments
Post Details
Added on Feb 12 2024
2 comments
32 views