Database transfer: Download the script and grant permissions for the DB2 database users
Note that manual steps from the Configuration Wizard can be found in the IBM Knowledge Center.
- Copy the downloaded script to the database server and extract it.
- Run the SQL statements listed in this script in the SQL processor. db2 -tvf SetupDB2Database.sql
Example of the script generated by the Configuration Wizard.
CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT CONNECT ON DATABASE TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_BASE_RUNTIME_USERS; GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ACL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ACL_ENTRY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ACTION_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ACTION_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ACTION_SET TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ACTION_SET_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.APP_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.APP_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.APP_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.AUTH_LEVEL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CLIENT_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CLIENT_DESC_CAPS TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.COMP_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.COMP_INST_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.COMP_INST_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.COMP_INST_DRAFT_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.COMP_INST_DRAFT_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.COMP_INST_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CONTENT_MAPPING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CONTENT_MAPPING_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CP_FILTER_DATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CP_FILTER_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CRED_SEGMENT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CRED_SLOT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.CRED_SLOT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.DEVICE_CLASS_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.DEVICE_CLASS_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.EVT_HANDLER TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.EVT_INTERFACE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LANG_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LANG_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_PAGE_DC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_PAGE_DC_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_PAGE_PORT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_PAGE_PORT_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_RES_TYPE_AS TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_RES_TYPE_RES TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_RESTYPE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_THEME_SKIN TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_USER_ROLE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.LNK_USER_ROLE_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.MARKUP_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.MARKUP_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_CONFIG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_CONFIG_VAR TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_COOKIE_RULE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_COOKIE_RULE_CN TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_COOKIE_RULE_TR TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_MAPPING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_MAPPING_IP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_MAPPING_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_POLICY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_POLICY_AM TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_POLICY_FC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_POLICY_HD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_POLICY_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.OUTBOUND_POLICY_MT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_ACT_ASC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_ACT_ASC_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_ACT_ASC_DRAFT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_ACT_ASC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_DRAFT_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_DRAFT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_DRAFT_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_INST_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_LAYOUT_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_LAYOUT_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_LAYOUT_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PAGE_LAYOUT_DESC_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_DIALOG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_DIALOG_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_DIALOG_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_TRANSITION TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_TRANSITION_ENDPOINT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_TRANSITION_ENDPOINT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_TRANSITION_ENDPOINT_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_TRANSITION_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PCM_TRANSITION_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_ACT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_ACT_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_ACT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_ACT_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_DESC_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_INST_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_INST_DRAFT_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_INST_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_PARM TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_PARM_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_PROP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_PROP_ALIAS TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_PROP_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_DRAFT_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_DRAFT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_DRAFT_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORT_WIRE_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORTAL_URL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PORTAL_URL_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PROT_RES TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PROT_RES_DEP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PROT_RES_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_CATEGORY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_CATEGORY_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_CATEGORY_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_SOURCE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_SOURCE_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PSE_SOURCE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PUB_REND_PARM TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PUB_REND_PARM_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.PUB_REND_PARM_QN TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.RES_TYPE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.RES_TYPE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ROLE_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.ROLE_INST_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SEARCH_REG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SEARCH_REG_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERV_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERV_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERV_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERV_DESC_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERV_DESC_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERVER_INFO TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERVER_INFO_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SERVER_INFO_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SKIN_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SKIN_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SKIN_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.SKIN_DESC_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.THEME_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.THEME_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.THEME_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.THEME_DESC_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.UNIQUE_NAME TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.UNIQUE_NAME_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.URL_MAP_CTX TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.URL_MAP_CTX_LBLS TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.USER_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.USER_DESC_STATE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.VANITY_URL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.VANITY_URL_DRAFT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.VAULT_DATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.VAULT_RESOURCES TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.VP_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.VP_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WEB_MOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WEB_MOD_UATTR TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WF_DATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WF_DEF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WF_DEF_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WF_TP_MAPPING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WF_TP_MAPPING_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WP_SEARCH_REG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WPS_SCDLMGR TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WPS_SCDLMPR TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WPS_SCDTASK TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WPS_SCDTREG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WSRP_PROD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WSRP_PROD_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WSRP_PROD_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WSRP_PROD_PORT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE release.WSRP_PROD_UATTR TO GROUP WP_BASE_RUNTIME_USERS; CONNECT RESET; CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT CONNECT ON DATABASE TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_BASE_RUNTIME_USERS; GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.ACL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.ACL_ENTRY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.AUTH_LEVEL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATA_ENTRY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATA_ENTRY_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATA_ENTRY_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATA_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CATE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.COMP_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.COMP_INST_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.COMP_INST_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CONTACTS_GROUP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CONTACTS_MEMBER TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CONTACTS_MEMBER_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CONTENT_MAPPING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CP_RESOURCE_RATING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CP_RESOURCE_TAG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CRED_SEGMENT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CRED_SLOT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.CRED_SLOT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.LNK_MEMBER_GROUP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.LNK_USER_ROLE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PAGE_ACT_ASC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PAGE_ACT_ASC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PAGE_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PAGE_INST_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PAGE_INST_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PAGE_INST_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_ACT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_ACT_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_ACT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_ACT_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_INST_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_PARM TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_PARM_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_PROP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_PROP_ALIAS TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_PROP_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_WIRE_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_WIRE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PORT_WIRE_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PROT_RES TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.PROT_RES_DEP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.ROLE_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.UNIQUE_NAME TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.VAULT_DATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE customization.VAULT_RESOURCES TO GROUP WP_BASE_RUNTIME_USERS; CONNECT RESET; CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT CONNECT ON DATABASE TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_BASE_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_BASE_RUNTIME_USERS; GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.ACL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.ACL_ENTRY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_APP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_APP_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_APP_METADATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_APP_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_BC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_BC_META_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_BC_METADATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_BC_VAR TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_BC_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_CATEGORY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_CATEGORY_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_PARM TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_PARM_BCMD_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_PARM_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_RSTR_PT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_TEMP_METADATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_TEMPLATE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_TEMPLATE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_TEMPLATE_ZIP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_TFOLDER TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_TFOLDER_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AI_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.APP_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.APP_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.APP_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.AUTH_LEVEL TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.COMP_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.COMP_INST_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.COMP_INST_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.CONTENT_MAPPING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.CP_CATEGORY TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.CP_CUSTOMRESOURCE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.CP_RESOURCE_RATING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.CP_RESOURCE_TAG TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.CP_RESOURCE_UPDATED TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.HASHED_BLOB TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.LNK_USER_ROLE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.LOC_DATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.LOC_DATA_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PAGE_ACT_ASC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PAGE_ACT_ASC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PAGE_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PAGE_INST_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PAGE_INST_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PAGE_INST_MAD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_ACT TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_ACT_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_ACT_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_ACT_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_DESC TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_DESC_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_DESC_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_DESC_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_INST_PREF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_PARM TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_PARM_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_PROP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_PROP_ALIAS TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_PROP_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_WIRE TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_WIRE_DD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_WIRE_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PORT_WIRE_MD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PROT_RES TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.PROT_RES_DEP TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.ROLE_INST TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.UNIQUE_NAME TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.WF_DATA TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.WF_DEF TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.WF_DEF_LOD TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.WF_TP_MAPPING TO GROUP WP_BASE_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE community.WF_TP_MAPPING_DD TO GROUP WP_BASE_RUNTIME_USERS; CONNECT RESET; CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT CONNECT ON DATABASE TO GROUP WP_JCR_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_JCR_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_JCR_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_JCR_RUNTIME_USERS; GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.ACL TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.ACL_ENTRY TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.CONTENT_MAPPING TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.LNK_USER_ROLE TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.PROT_RES TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.PROT_RES_DEP TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.ROLE_INST TO GROUP WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE jcr.UNIQUE_NAME TO GROUP WP_JCR_RUNTIME_USERS; CONNECT RESET; CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT CONNECT ON DATABASE TO GROUP WP_PZN_RUNTIME_USERS; GRANT DBADM ON DATABASE TO GROUP WP_PZN_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_PZN_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_PZN_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_PZN_RUNTIME_USERS; GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.AGGREGATEKEY TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.AGGREGATES TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.AGGREGATESTATUS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.AGGREGATE_CONTENT TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.BROWSERS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.CALENDAR TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.CATEGORIES TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.CATEGORYMAP TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.CATEGORY_PATTERNS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.CATEGORY_SETS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.COOKIESSTATUS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.DOMAIN TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.ENTITIES TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.ENTITYTRAVERSAL TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.HITPARMS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.HIT_FACTS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.HTTPVERSION TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.IMPORTHISTORY TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.JAVASCRIPTSTATUS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.KEY TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.KEY_VALUE_COMBO TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.KEY_VALUE_PAIR TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.LINKAGE TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.LOGCONTROL TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.LOGS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.LOG_FILE_STATUS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.NETWORKS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.PARMS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.PLATFORMS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.PROTOCOLS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.REFERRER TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.REFERRERHOST TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.REFERRERURL TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.RESETSTATUS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.RESOURCES TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.RESULT TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.RETURNCODES TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.SERVERNODES TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.SERVERS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.SESSIONPARMS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.SESSION_FACTS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.SUBDOMAINS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.TIMEOFDAY TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.TIMESPAN TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.USERAGENTS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.USERS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.VALUE TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON feedback.WEB_NODES TO WP_PZN_RUNTIME_USERS; CONNECT RESET; CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT CONNECT ON DATABASE TO GROUP WP_PZN_RUNTIME_USERS; GRANT DBADM ON DATABASE TO GROUP WP_PZN_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN100 TO GROUP WP_PZN_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN200 TO GROUP WP_PZN_RUNTIME_USERS; GRANT EXECUTE ON PACKAGE NULLID.SYSSN300 TO GROUP WP_PZN_RUNTIME_USERS; GRANT USAGE ON WORKLOAD SYSDEFAULTUSERWORKLOAD TO GROUP WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_ADMIN_USERS TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_CFG TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_ITEM_DATA TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_MBA_SCORED TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_RTG_POOL TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_TRX_MENTOR TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_TRX_POOL TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_TRX_TYPE TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_USER_DATA TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_USER_MENTOR TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_USER_RATING TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_USER_TRX TO WP_PZN_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON likeminds.LPS_VISIT_LIST TO WP_PZN_RUNTIME_USERS; CONNECT RESET; CONNECT TO WPSDB USER dba_ID USING dba_pwd; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_OBJECTS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_TIMERS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.JOBS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.OBJECTS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.TASKJOBMAPPING TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.TASKS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_USER_SHORTCUT TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_CONTROLLABLES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_LIBRARIES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_PROJECTS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_PROJLIBS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_SYNDICATORS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_SYNDLIBS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_VERSIONS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_VPORTALS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_SYND_FAILURE TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_SYND_SESSION TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.WCM_SYND_EXTRA_DATA TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.OPENJPA_SEQUENCE_TABLE TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTADMINDOMAINS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTACCESSCODES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTCOLLNAME TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTSYSCONTROL TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTATTRDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTATTRGROUP TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTNLSLANGUAGES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTMAXKEYWORD TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTNLSKEYWORDS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTITEMTYPEDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTITVIEWDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTITVIEWID TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTCOMPDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTCOMPATTRS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTCOMPATTRSFK TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTCOMPVIEWDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTCOMPVIEWATTRS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTITEMS001001 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTITEMVER001001 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTLINKS001001 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTMIMETYPES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTITEMSTODELETE TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTXDOOBJECTS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTRI001001 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTVIEWACCESS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMUT00600001 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRNODELOCKS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRWS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRNSURIS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRNSPREFIXES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMUTSWIDE0 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMUTMWIDE0 TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRWSNODES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRLINKS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRDELTALINKS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRLINKREL TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRDELTALR TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRGLBLPROPS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRADDTLPROPS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRNODETYPES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRPROPDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRNODEDEFS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRRNODETYPES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRSUPERTYPES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTIMESTAMPS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRIDS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRDUMMY TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRMAXSNSIDX TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRGENDDL TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRINDEXNAMES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRINDEXES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSPENDING TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSERRORS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSINDEXES TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSPATHINFO TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSPOSCOR TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSNEGCOR TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRAPPL TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRNODEREGISTER TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSFULLCRAWLTOPICS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSSUBSCRIPTIONMANAGER TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSSEEDLISTPENDING TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRTSINCSUBSMSGS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCREDITIONINFO TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCREDITIONS TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRREMOVEHLP TO WP_JCR_RUNTIME_USERS; GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ICMSTJCRIMPORTREF TO WP_JCR_RUNTIME_USERS; CONNECT RESET;