Database Administration (MOSC)

MOSC Banner

Cannot grant execute to sys.dbms_lock to any user

edited Oct 20, 2022 3:38PM in Database Administration (MOSC) 7 commentsAnswered

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center