Cisco Cisco Workload Automation 6.3 ユーザーガイド

Appendix A—Custom APPS User SQL Commands

sys_grant.sql Commands

CREATE OR REPLACE SYNONYM FND_SECURITY_GROUPS_VL FOR APPS.FND_SECURITY_GROUPS_VL; 

CREATE OR REPLACE SYNONYM FND_SESSIONS FOR APPS.FND_SESSIONS; 

CREATE OR REPLACE SYNONYM FND_SUBMIT FOR APPS.FND_SUBMIT;

CREATE OR REPLACE SYNONYM FND_S_FILE_TEMP_ID FOR APPLSYS.FND_S_FILE_TEMP_ID;

CREATE OR REPLACE SYNONYM FND_TERRITORIES FOR APPS.FND_TERRITORIES; 

CREATE OR REPLACE SYNONYM FND_USER FOR APPS.FND_USER; 

CREATE OR REPLACE SYNONYM FND_USER_PREFERENCE FOR APPLSYS.FND_USER_PREFERENCES; 

CREATE OR REPLACE SYNONYM FND_USER_PREFERENCES FOR APPS.FND_USER_PREFERENCES;

CREATE OR REPLACE SYNONYM FND_USER_RESP_GROUPS FOR APPS.FND_USER_RESP_GROUPS; 

CREATE OR REPLACE SYNONYM FND_WEBFILE FOR APPS.FND_WEBFILE; 

CREATE OR REPLACE SYNONYM FND_WEB_SEC FOR APPS.FND_WEB_SEC;

CREATE OR REPLACE SYNONYM GET_REQUEST_SET_PRIORITY FOR APPS.GET_REQUEST_SET_PRIORITY;

CREATE OR REPLACE SYNONYM HR_SIGNON FOR APPS.HR_SIGNON;

CREATE OR REPLACE SYNONYM HTP FOR APPS.HTP;

CREATE OR REPLACE SYNONYM ICX_CALL FOR APPS.ICX_CALL;

CREATE OR REPLACE SYNONYM ICX_PARAMETERS FOR APPS.ICX_PARAMETERS; 

CREATE OR REPLACE SYNONYM JG_CONTEXT FOR APPS.JG_CONTEXT;

CREATE OR REPLACE SYNONYM MO_GLOBAL FOR APPS.MO_GLOBAL;

CREATE OR REPLACE SYNONYM SABDG_JOBS FOR SABDG.SABDG_JOBS; 

CREATE OR REPLACE SYNONYM SABDG_JOBS_S FOR SABDG.SABDG_JOBS_S; 

CREATE OR REPLACE SYNONYM SABDG_MENU_TEMP FOR SABDG.SABDG_MENU_TEMP; 

CREATE OR REPLACE SYNONYM SABDG_MENU_TEMP_S FOR SABDG.SABDG_MENU_TEMP_S; 

CREATE OR REPLACE SYNONYM SABDG_PARAMETERS FOR SABDG.SABDG_PARAMETERS;

CREATE OR REPLACE SYNONYM SABDG_RELEASED_REQS FOR SABDG.SABDG_RELEASED_REQS;

CREATE OR REPLACE SYNONYM UTL_RAW FOR SYS.UTL_RAW;

CREATE OR REPLACE SYNONYM WF_ROLES FOR APPS.WF_ROLES;

sys_grant.sql Commands

GRANT EXECUTE ON "SYS"."DBMS_APPLICATION_INFO" TO "TIDAL";

GRANT DEBUG ON "SYS"."DBMS_OBFUSCATION_TOOLKIT" TO "TIDAL";

GRANT EXECUTE ON "SYS"."DBMS_OBFUSCATION_TOOLKIT" TO "TIDAL";

GRANT EXECUTE ON "SYS"."DBMS_SYSTEM" TO "TIDAL";

GRANT SELECT ON "SYS"."ERROR$" TO "TIDAL";

GRANT EXECUTE ON "SYS"."HTP" TO "TIDAL";

GRANT SELECT ON "SYS"."TRIGGER$" TO "TIDAL";

GRANT DEBUG ON "SYS"."UTL_RAW" TO "TIDAL";

GRANT EXECUTE ON "SYS"."UTL_RAW" TO "TIDAL";