Database transfer: Download the script and grant permissions for the Oracle database users

Manual steps from the Configuration Wizard are included in HCL Digital Experience Product Documentation for reference and for advanced users. The procedure includes variables and steps for different databases. When you use the wizard to configure your deployment, it replaces the variable with information that you provided in the wizard. It also shows only the steps that are specific to your environment. The instructions that the wizard generates are specific to your environment.

Attention: All steps for all database environments are included without consideration for your environment. Use the Configuration Wizard to generate custom instructions for your environment.

1. Copy the downloaded script to the database server and extract it.

2. Run the SQL statements that are listed in this script in your SQL processor.

   Example of the script that is generated by the Configuration Wizard:

   CREATE ROLE WP_BASE_RUNTIME_USERS NOT IDENTIFIED;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ACL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PROT_RES TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ACL_ENTRY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ROLE_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_USER_ROLE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.UNIQUE_NAME TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PROT_RES_DEP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CONTENT_MAPPING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_INST_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.COMP_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.COMP_INST_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.COMP_INST_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_ACT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_ACT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_ACT_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_ACT_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_PROP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_PROP_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_PROP_ALIAS TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_PARM TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_PARM_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_ACT_ASC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_ACT_ASC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.AUTH_LEVEL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.VAULT_RESOURCES TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.VAULT_DATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CRED_SEGMENT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CRED_SLOT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CRED_SLOT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.APP_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.APP_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.APP_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_DESC_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WF_DEF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WF_DEF_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WF_DATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WF_TP_MAPPING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WF_TP_MAPPING_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WEB_MOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WEB_MOD_UATTR TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WSRP_PROD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WSRP_PROD_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WSRP_PROD_UATTR TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WSRP_PROD_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WSRP_PROD_PORT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERV_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERV_DESC_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERV_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERV_DESC_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERV_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PUB_REND_PARM TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PUB_REND_PARM_QN TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PUB_REND_PARM_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SKIN_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SKIN_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SKIN_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SKIN_DESC_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.THEME_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.THEME_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.THEME_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.THEME_DESC_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_LAYOUT_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_LAYOUT_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_LAYOUT_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_LAYOUT_DESC_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERVER_INFO TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERVER_INFO_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SERVER_INFO_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.USER_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.USER_DESC_STATE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.URL_MAP_CTX TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.URL_MAP_CTX_LBLS TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_PAGE_PORT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_THEME_SKIN TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.MARKUP_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.MARKUP_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CLIENT_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CLIENT_DESC_CAPS TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LANG_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LANG_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.EVT_HANDLER TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.EVT_INTERFACE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORTAL_URL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORTAL_URL_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.VP_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.VP_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ACTION_SET TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ACTION_SET_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ACTION_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ACTION_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.RES_TYPE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.RES_TYPE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_RES_TYPE_RES TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_RES_TYPE_AS TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_RESTYPE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_CATEGORY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_CATEGORY_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_CATEGORY_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_SOURCE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_SOURCE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PSE_SOURCE_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WP_SEARCH_REG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SEARCH_REG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.SEARCH_REG_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CP_FILTER_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CP_FILTER_DATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.DEVICE_CLASS_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_PAGE_DC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.DEVICE_CLASS_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.VANITY_URL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_CONFIG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_CONFIG_VAR TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_MAPPING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_MAPPING_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_MAPPING_IP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_POLICY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_POLICY_AM TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_POLICY_FC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_POLICY_HD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_POLICY_MT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_POLICY_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_COOKIE_RULE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_COOKIE_RULE_CN TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.OUTBOUND_COOKIE_RULE_TR TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_DIALOG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_DIALOG_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_DIALOG_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_TRANSITION_ENDPOINT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_TRANSITION_ENDPOINT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_TRANSITION_ENDPOINT_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_TRANSITION TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_TRANSITION_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PCM_TRANSITION_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_DRAFT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_DRAFT_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_INST_DRAFT_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_INST_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_INST_DRAFT_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.COMP_INST_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.COMP_INST_DRAFT_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.COMP_INST_DRAFT_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.UNIQUE_NAME_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PROT_RES_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.ROLE_INST_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_USER_ROLE_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.CONTENT_MAPPING_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_DRAFT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_DRAFT_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PORT_WIRE_DRAFT_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_ACT_ASC_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.PAGE_ACT_ASC_DRAFT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_PAGE_PORT_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.LNK_PAGE_DC_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.VANITY_URL_DRAFT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WPS_SCDTASK TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WPS_SCDTREG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WPS_SCDLMGR TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON release.WPS_SCDLMPR TO WP_BASE_RUNTIME_USERS;
   
   
   CREATE ROLE WP_BASE_RUNTIME_USERS NOT IDENTIFIED;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.ACL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PROT_RES TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.ACL_ENTRY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.ROLE_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.LNK_USER_ROLE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.UNIQUE_NAME TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PROT_RES_DEP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CONTENT_MAPPING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PAGE_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PAGE_INST_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PAGE_INST_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PAGE_INST_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_INST_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.COMP_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.COMP_INST_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.COMP_INST_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_ACT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_ACT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_ACT_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_ACT_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_PROP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_PROP_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_PROP_ALIAS TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_PARM TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_PARM_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_WIRE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_WIRE_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PORT_WIRE_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PAGE_ACT_ASC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.PAGE_ACT_ASC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.AUTH_LEVEL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.VAULT_RESOURCES TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.VAULT_DATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CRED_SEGMENT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CRED_SLOT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CRED_SLOT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CP_RESOURCE_TAG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CP_RESOURCE_RATING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CONTACTS_MEMBER TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CONTACTS_MEMBER_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CONTACTS_GROUP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.LNK_MEMBER_GROUP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATA_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATA_ENTRY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATA_ENTRY_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON customization.CATA_ENTRY_DD TO WP_BASE_RUNTIME_USERS;
   
   
   CREATE ROLE WP_BASE_RUNTIME_USERS NOT IDENTIFIED;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.ACL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PROT_RES TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.ACL_ENTRY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.ROLE_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.LNK_USER_ROLE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.UNIQUE_NAME TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PROT_RES_DEP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.CONTENT_MAPPING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PAGE_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PAGE_INST_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PAGE_INST_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PAGE_INST_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_INST_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.COMP_INST TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.COMP_INST_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.COMP_INST_MAD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_ACT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_ACT_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_ACT_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_ACT_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_PROP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_PROP_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_PROP_ALIAS TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_PARM TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_PARM_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_WIRE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_WIRE_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_WIRE_MD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PAGE_ACT_ASC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PAGE_ACT_ASC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AUTH_LEVEL TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.APP_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.APP_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.APP_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_DESC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_DESC_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_DESC_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.PORT_DESC_PREF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.WF_DEF TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.WF_DEF_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.WF_DATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.WF_TP_MAPPING TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.WF_TP_MAPPING_DD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_CATEGORY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_CATEGORY_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_TFOLDER TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_TFOLDER_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_TEMPLATE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_TEMPLATE_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_TEMPLATE_ZIP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_TEMP_METADATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_APP TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_APP_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_APP_METADATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_RSTR_PT TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_BC TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_BC_METADATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_BC_VAR TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_PARM TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_PARM_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_BC_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_APP_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_BC_META_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.AI_PARM_BCMD_WIRE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.CP_CUSTOMRESOURCE TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.CP_CATEGORY TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.LOC_DATA TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.LOC_DATA_LOD TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.HASHED_BLOB TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.CP_RESOURCE_UPDATED TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.CP_RESOURCE_TAG TO WP_BASE_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON community.CP_RESOURCE_RATING TO WP_BASE_RUNTIME_USERS;
   
   
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ACL TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.PROT_RES TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ACL_ENTRY TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.ROLE_INST TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.LNK_USER_ROLE TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.UNIQUE_NAME TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.PROT_RES_DEP TO WP_JCR_RUNTIME_USERS;
   GRANT SELECT, INSERT, UPDATE, DELETE ON jcr.CONTENT_MAPPING TO WP_JCR_RUNTIME_USERS;
   
   
   CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
   GRANT
     CREATE SESSION
   TO
     WP_PZN_RUNTIME_USERS;
   GRANT
     SELECT ON DBA_PENDING_TRANSACTIONS
   TO
     WP_PZN_RUNTIME_USERS;
   CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
   GRANT CREATE SESSION TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO 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;
   GRANT SELECT ON feedback.AGGREGATESTATUS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.AGGREGATES_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.BROWSERS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.CALENDAR_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.CATEGORIES_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.CATEGORY_PATTERNS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.CATEGORY_SETS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.COOKIESSTATUS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.DOMAIN_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.ENTITIES_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.ENTITYTRAVERSAL_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.HIT_FACTS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.HTTPVERSION_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.IMPORTHISTORY_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.JAVASCRIPTSTATUS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.KEY_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.KEY_VALUE_PAIR_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.LINKAGE_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.LOGS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.LOG_FILE_STATUS_RES_ID_1 TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.LOG_FILE_STATUS_RES_ID_2 TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.NETWORKS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.PARMS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.PLATFORMS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.PROTOCOLS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.REFERRERHOST_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.REFERRERURL_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.REFERRER_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.RESETSTATUS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.RESOURCES_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.RESULT_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.RETURNCODES_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.SERVERS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.SESSION_FACTS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.SUBDOMAINS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.TIMEOFDAY_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.TIMESPAN_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.USERAGENTS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.USERS_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.VALUE_ID TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON feedback.WEB_NODES_ID TO WP_PZN_RUNTIME_USERS;
   CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
   GRANT CREATE SESSION TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_PZN_RUNTIME_USERS;
   
   
   CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
   GRANT
     CREATE SESSION
   TO
     WP_PZN_RUNTIME_USERS;
   GRANT
     SELECT ON DBA_PENDING_TRANSACTIONS
   TO
     WP_PZN_RUNTIME_USERS;
   CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
   GRANT CREATE SESSION TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO 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;
   CREATE ROLE WP_PZN_RUNTIME_USERS NOT IDENTIFIED;
   GRANT CREATE SESSION TO WP_PZN_RUNTIME_USERS;
   GRANT SELECT ON DBA_PENDING_TRANSACTIONS TO WP_PZN_RUNTIME_USERS;
   
   
   
   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;