PL/SQL (MOSC)

MOSC Banner

Grant permissions to specific procedures/functions inside package

edited Jul 22, 2019 2:49AM in PL/SQL (MOSC) 6 commentsAnswered ✓

Hi

Oracle 12.1.0.2.0

If I have package P, and this package has functions and procedures defined:

CREATE OR REPLACE PACKAGE PASPROCEDURE F1 (ID IN NUMBER);PROCEDURE P1 (ID IN NUMBER);..END P;....

I know I can grant permissions to this specific package:

GRANT EXECUTE, DEBUG ON P TO <<role_name>>;

But is there a possibility that I can grant permissions to specific function or procedure inside this package P..?

Raul

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