Mega Code Archive
Create grant permission command by querying user_objects table
<![CDATA[
SQL>
SQL> SELECT 'GRANT EXECUTE ON ' || object_name || ' TO ' ||
2 UPPER('&user_role') || ';'
3 FROM user_objects
4 WHERE object_type IN ('PACKAGE','PROCEDURE','FUNCTION')
5 and rownum < 50
6 ORDER BY object_type, object_name;
Enter value for user_role:
old 2: UPPER('&user_role') || ';'
new 2: UPPER('') || ';'
GRANT EXECUTE ON CHITIME TO ;
GRANT EXECUTE ON GRPVAL TO ;
GRANT EXECUTE ON IS_OVERDUE TO ;
GRANT EXECUTE ON RECEIVE_MESSAGE TO ;
GRANT EXECUTE ON RULERSTR TO ;
GRANT EXECUTE ON TABCOUNT TO ;
GRANT EXECUTE ON TO_MMSDDSYYYY_OR_NULL TO ;
GRANT EXECUTE ON TO_NUMBER_OR_NULL TO ;
GRANT EXECUTE ON TRACEIT TO ;
GRANT EXECUTE ON VALUE_IN TO ;
GRANT EXECUTE ON CLASSPACKAGE TO ;
GRANT EXECUTE ON DATES TO ;
GRANT EXECUTE ON GENDER_TS TO ;
GRANT EXECUTE ON MYDATE TO ;
GRANT EXECUTE ON ONECUR TO ;
GRANT EXECUTE ON PARAMETERS TO ;
GRANT EXECUTE ON SALESPKG TO ;
GRANT EXECUTE ON SCOPES TO ;
GRANT EXECUTE ON TIMER TO ;
GRANT EXECUTE ON VALERR TO ;
GRANT EXECUTE ON WORKER_TS TO ;
GRANT EXECUTE ON WORKER_TYPE_TS TO ;
GRANT EXECUTE ON WORKPLACE_TYPE_TS TO ;
GRANT EXECUTE ON BULK_TEST TO ;
GRANT EXECUTE ON CLOSECUR TO ;
GRANT EXECUTE ON CREINDX TO ;
GRANT EXECUTE ON DELETE_CUST TO ;
GRANT EXECUTE ON DROPIT TO ;
GRANT EXECUTE ON DROP_IF_EXISTS TO ;
GRANT EXECUTE ON FCREATE TO ;
GRANT EXECUTE ON FLUSH TO ;
GRANT EXECUTE ON GET_LINE TO ;
GRANT EXECUTE ON P1 TO ;
GRANT EXECUTE ON PRINTLN TO ;
GRANT EXECUTE ON PROC0 TO ;
GRANT EXECUTE ON PROC1 TO ;
GRANT EXECUTE ON PROC2 TO ;
GRANT EXECUTE ON PROC3 TO ;
GRANT EXECUTE ON PROCA TO ;
GRANT EXECUTE ON PROCB TO ;
GRANT EXECUTE ON PUT_BOOLEAN TO ;
GRANT EXECUTE ON P_RUN_INSERT TO ;
GRANT EXECUTE ON ROW_AT_A_TIME_TEST TO ;
GRANT EXECUTE ON RUNDDL TO ;
GRANT EXECUTE ON SAVESTRINGTOFILE TO ;
GRANT EXECUTE ON SEND_MESSAGE TO ;
GRANT EXECUTE ON SHOWEMPS TO ;
GRANT EXECUTE ON SHOW_FILE TO ;
GRANT EXECUTE ON WAIT TO ;
49 rows selected.
]]>