"Oracle user needs execute access on DBMS_LOCK" error messages are back
our DBAs had assigned the authorization and the error messages were gone. With the update to v9.9 I took a closer look at the logs again and unfortunately the error message is back !?
Of course I first checked the DB user permissions, but this looks fine - see screenshot. I can display the data of the two views mentioned (SYS.V_$LOCK and SYS.V_$SESSION), as well as "begin DBMS_LOCK.SLEEP(1); End; " successfully. Both of these together indicate that the permissions are correct and working as well.
Only YF doesn't notice it anymore and reports again :
YF:2023-08-04 11:40:55.625: WARN (OracleLockService) - Error during capability test for oracle session locking: java.sql.SQLSyntaxErrorException: ORA-00942: Tabelle oder View nicht vorhanden
YF:2023-08-04 11:40:55.625: WARN (OracleLockService) - Oracle user needs execute access on DBMS_LOCK, and select access on SYS.V_$LOCK and SYS.V_$SESSION to use session locking
Please check this on your end.