Database Administration (MOSC)

MOSC Banner

privilege to grant to a non-dba app user account to grant execute on SYS proc/pkgs

edited Sep 19, 2022 7:37PM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi

What privilege do we need to grant a non-dba app user to grant the execute on the SYS owned proc/pkg to other users in the database?


Example:

GRANT GRANT ANY PRIVILEGE TO SPULI_TEST123 ;

This works for the below but not the one in the end.

GRANT DEBUG CONNECT ANY TO HRC10001; -- grant succeeded

GRANT DEBUG ANY PROCEDURE TO HRC10001;-- grant succeeded


GRANT EXECUTE ON SYS.DBMS_DEBUG_JDWP to HRC10001; -- insufficient privileges

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