Suppose A Package Pack.a With A Procedure Proc_1 Exists In The Schema

1.	Suppose A Package Pack.a With A Procedure Proc_1 Exists In The Schema Sample_one_schema. If The Schema Sample_two_schema Needs To Be Given Privilege To Execute The Procedure Proc_1, Which Privilege Has To Be Granted ?
Answer» The statement is as FOLLOWS: GRANT EXECUTE ON PACK_A TO SAMPLE_TWO_SCHEMA The privilege is always granted on the whole PACKAGE and not on the individual procedures or functions. The statement is as follows: The privilege is always granted on the whole package and not on the individual procedures or functions.

Suppose A Package Pack.a With A Procedure Proc_1 Exists In The Schema Sample_one_schema. If The Schema Sample_two_schema Needs To Be Given Privilege To Execute The Procedure Proc_1, Which Privilege Has To Be Granted ?

Answer»

The statement is as FOLLOWS:

GRANT EXECUTE ON PACK_A TO SAMPLE_TWO_SCHEMA

The privilege is always granted on the whole PACKAGE and not on the individual procedures or functions.

The statement is as follows:

The privilege is always granted on the whole package and not on the individual procedures or functions.