Cannot grant execute to sys.dbms_lock to any user
Hi team,
As a sys admin having the username as system, I am unable to execute sys.dbms_lock privilege to system user as well as to any other user. When I am executing this statement "GRANT execute on sys.dbms_lock to system with grant option" it is showing output as 2. (granting access to sysdba user)
In another case , I am also unable to give sys.dbms_lock privilege to any other user as well, resulting into an error saying "insufficient privileges". As sysdba user having username, system, how should I be able to grant the sysdba, the sys.dbms_lock privilege and then to any other user ?