Database transfer: Download the script and grant permissions for the Oracle database users | HCL Digital Experience

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;