TheHRusercreatesastand-aloneprocedureasfollowsandgrantstheEXECUTEprivilegeontheproceduretomanydatabaseusers:
CREATEORREPLACEPROCEDUREcreate_dept(v_deptnoNUMBER,v_dnameVARCHAR2,v_mgrNUMBER,v_locNUMBER)BEGIN
INSERTINTOhr.departmentsVALUES(v_deptno,v_dname,v_mgr,v_loc);END;
Theusershavingpermissiontoexecutetheprocedureareabletoinsertrecordsintothe
DEPARTMENTStableeventhoughtheydonothavetheINSERTprivilegeonthetable.YouwantonlythoseuserswhohaveprivilegesontheDEPARTMENTStabletobeabletoexecutetheproceduresuccessfully.
WhatwouldyousuggesttothePL/SQLdeveloperstoachievethis()