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

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

USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ACL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PROT_RES] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ACL_ENTRY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ROLE_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_USER_ROLE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[UNIQUE_NAME] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PROT_RES_DEP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CONTENT_MAPPING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_INST_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[COMP_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[COMP_INST_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[COMP_INST_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_ACT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_ACT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_ACT_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_ACT_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_PROP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_PROP_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_PROP_ALIAS] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_PARM] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_PARM_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_ACT_ASC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_ACT_ASC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[AUTH_LEVEL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[VAULT_RESOURCES] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[VAULT_DATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CRED_SEGMENT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CRED_SLOT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CRED_SLOT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[APP_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[APP_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[APP_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_DESC_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WF_DEF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WF_DEF_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WF_DATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WF_TP_MAPPING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WF_TP_MAPPING_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WEB_MOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WEB_MOD_UATTR] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WSRP_PROD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WSRP_PROD_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WSRP_PROD_UATTR] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WSRP_PROD_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WSRP_PROD_PORT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERV_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERV_DESC_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERV_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERV_DESC_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERV_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PUB_REND_PARM] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PUB_REND_PARM_QN] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PUB_REND_PARM_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SKIN_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SKIN_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SKIN_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SKIN_DESC_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[THEME_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[THEME_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[THEME_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[THEME_DESC_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_LAYOUT_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_LAYOUT_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_LAYOUT_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_LAYOUT_DESC_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERVER_INFO] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERVER_INFO_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SERVER_INFO_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[USER_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[USER_DESC_STATE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[URL_MAP_CTX] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[URL_MAP_CTX_LBLS] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_PAGE_PORT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_THEME_SKIN] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[MARKUP_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[MARKUP_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CLIENT_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CLIENT_DESC_CAPS] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LANG_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LANG_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[EVT_HANDLER] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[EVT_INTERFACE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORTAL_URL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORTAL_URL_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[VP_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[VP_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ACTION_SET] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ACTION_SET_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ACTION_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ACTION_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[RES_TYPE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[RES_TYPE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_RES_TYPE_RES] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_RES_TYPE_AS] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_RESTYPE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_CATEGORY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_CATEGORY_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_CATEGORY_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_SOURCE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_SOURCE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PSE_SOURCE_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WP_SEARCH_REG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SEARCH_REG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[SEARCH_REG_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CP_FILTER_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CP_FILTER_DATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[DEVICE_CLASS_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_PAGE_DC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[DEVICE_CLASS_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[VANITY_URL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_CONFIG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_CONFIG_VAR] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_MAPPING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_MAPPING_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_MAPPING_IP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_POLICY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_POLICY_AM] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_POLICY_FC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_POLICY_HD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_POLICY_MT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_POLICY_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_COOKIE_RULE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_COOKIE_RULE_CN] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[OUTBOUND_COOKIE_RULE_TR] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_DIALOG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_DIALOG_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_DIALOG_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_TRANSITION_ENDPOINT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_TRANSITION_ENDPOINT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_TRANSITION_ENDPOINT_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_TRANSITION] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_TRANSITION_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PCM_TRANSITION_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_DRAFT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_DRAFT_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_INST_DRAFT_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_INST_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_INST_DRAFT_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[COMP_INST_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[COMP_INST_DRAFT_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[COMP_INST_DRAFT_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[UNIQUE_NAME_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PROT_RES_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[ROLE_INST_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_USER_ROLE_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[CONTENT_MAPPING_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_DRAFT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_DRAFT_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PORT_WIRE_DRAFT_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_ACT_ASC_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[PAGE_ACT_ASC_DRAFT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_PAGE_PORT_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[LNK_PAGE_DC_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[VANITY_URL_DRAFT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WPS_SCDTASK] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WPS_SCDTREG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WPS_SCDLMGR] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[release].[WPS_SCDLMPR] TO [WP_BASE_RUNTIME_USERS];


USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[ACL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PROT_RES] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[ACL_ENTRY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[ROLE_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[LNK_USER_ROLE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[UNIQUE_NAME] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PROT_RES_DEP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CONTENT_MAPPING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PAGE_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PAGE_INST_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PAGE_INST_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PAGE_INST_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_INST_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[COMP_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[COMP_INST_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[COMP_INST_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_ACT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_ACT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_ACT_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_ACT_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_PROP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_PROP_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_PROP_ALIAS] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_PARM] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_PARM_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_WIRE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_WIRE_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PORT_WIRE_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PAGE_ACT_ASC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[PAGE_ACT_ASC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[AUTH_LEVEL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[VAULT_RESOURCES] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[VAULT_DATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CRED_SEGMENT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CRED_SLOT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CRED_SLOT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CP_RESOURCE_TAG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CP_RESOURCE_RATING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CONTACTS_MEMBER] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CONTACTS_MEMBER_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CONTACTS_GROUP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[LNK_MEMBER_GROUP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATA_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATA_ENTRY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATA_ENTRY_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[customization].[CATA_ENTRY_DD] TO [WP_BASE_RUNTIME_USERS];


USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[ACL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PROT_RES] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[ACL_ENTRY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[ROLE_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[LNK_USER_ROLE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[UNIQUE_NAME] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PROT_RES_DEP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[CONTENT_MAPPING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PAGE_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PAGE_INST_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PAGE_INST_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PAGE_INST_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_INST_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[COMP_INST] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[COMP_INST_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[COMP_INST_MAD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_ACT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_ACT_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_ACT_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_ACT_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_PROP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_PROP_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_PROP_ALIAS] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_PARM] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_PARM_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_WIRE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_WIRE_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_WIRE_MD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PAGE_ACT_ASC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PAGE_ACT_ASC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AUTH_LEVEL] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[APP_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[APP_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[APP_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_DESC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_DESC_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_DESC_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[PORT_DESC_PREF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[WF_DEF] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[WF_DEF_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[WF_DATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[WF_TP_MAPPING] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[WF_TP_MAPPING_DD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_CATEGORY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_CATEGORY_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_TFOLDER] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_TFOLDER_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_TEMPLATE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_TEMPLATE_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_TEMPLATE_ZIP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_TEMP_METADATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_APP] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_APP_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_APP_METADATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_RSTR_PT] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_BC] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_BC_METADATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_BC_VAR] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_PARM] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_PARM_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_BC_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_APP_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_BC_META_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[AI_PARM_BCMD_WIRE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[CP_CUSTOMRESOURCE] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[CP_CATEGORY] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[LOC_DATA] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[LOC_DATA_LOD] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[HASHED_BLOB] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[CP_RESOURCE_UPDATED] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[CP_RESOURCE_TAG] TO [WP_BASE_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[community].[CP_RESOURCE_RATING] TO [WP_BASE_RUNTIME_USERS];


USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ACL] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[PROT_RES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ACL_ENTRY] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ROLE_INST] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[LNK_USER_ROLE] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[UNIQUE_NAME] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[PROT_RES_DEP] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[CONTENT_MAPPING] TO [WP_JCR_RUNTIME_USERS];


USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[AGGREGATE_CONTENT] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[AGGREGATEKEY] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[AGGREGATES] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[AGGREGATESTATUS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[BROWSERS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[CALENDAR] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[CATEGORIES] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[CATEGORY_PATTERNS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[CATEGORY_SETS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[CATEGORYMAP] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[COOKIESSTATUS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[DOMAIN] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[ENTITIES] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[ENTITYTRAVERSAL] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[HIT_FACTS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[HITPARMS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[HTTPVERSION] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[IMPORTHISTORY] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[JAVASCRIPTSTATUS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[KEY] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[KEY_VALUE_COMBO] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[KEY_VALUE_PAIR] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[LINKAGE] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[LOG_FILE_STATUS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[LOGCONTROL] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[LOGS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[NETWORKS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[PARMS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[PLATFORMS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[PROTOCOLS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[REFERRER] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[REFERRERHOST] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[REFERRERURL] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[RESETSTATUS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[RESOURCES] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[RESULT] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[RETURNCODES] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[SERVERNODES] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[SERVERS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[SESSION_FACTS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[SESSIONPARMS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[SUBDOMAINS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[TIMEOFDAY] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[TIMESPAN] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[USERAGENTS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[USERS] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[VALUE] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[feedback].[WEB_NODES] TO [WP_PZN_RUNTIME_USERS];


USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_admin_users] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_cfg] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_item_data] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_mba_scored] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_rtg_pool] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_trx_mentor] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_trx_pool] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_trx_type] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_user_data] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_user_mentor] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_user_rating] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_user_trx] TO [WP_PZN_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[likeminds].[lps_visit_list] TO [WP_PZN_RUNTIME_USERS];

GRANT EXECUTE ON OBJECT::[likeminds].[sp_lpsdeleteitem] TO [WP_PZN_RUNTIME_USERS];
GRANT EXECUTE ON OBJECT::[likeminds].[sp_lpsdeletetype] TO [WP_PZN_RUNTIME_USERS];
GRANT EXECUTE ON OBJECT::[likeminds].[sp_lpsdeleteuser] TO [WP_PZN_RUNTIME_USERS];



USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_OBJECTS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_TIMERS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[JOBS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[OBJECTS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[TASKJOBMAPPING] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[TASKS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_USER_SHORTCUT] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_CONTROLLABLES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_LIBRARIES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_PROJECTS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_PROJLIBS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_SYNDICATORS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_SYNDLIBS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_VERSIONS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_VPORTALS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_SYND_FAILURE] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_SYND_SESSION] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[WCM_SYND_EXTRA_DATA] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[OPENJPA_SEQUENCE_TABLE] TO [WP_JCR_RUNTIME_USERS];



  
USE [WPSDB];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTADMINDOMAINS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTACCESSCODES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTCOLLNAME] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTSYSCONTROL] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTATTRDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTATTRGROUP] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTNLSLANGUAGES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTMAXKEYWORD] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTNLSKEYWORDS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTITEMTYPEDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTITVIEWDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTITVIEWID] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTCOMPDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTCOMPATTRS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTCOMPATTRSFK] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTCOMPVIEWDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTCOMPVIEWATTRS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTITEMS001001] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTITEMVER001001] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTLINKS001001] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTMIMETYPES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTITEMSTODELETE] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTXDOOBJECTS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTRI001001] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTVIEWACCESS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMUT00600001] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRNODELOCKS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRWS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRNSURIS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRNSPREFIXES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMUTSWIDE0] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMUTMWIDE0] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRWSNODES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRLINKS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRDELTALINKS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRLINKREL] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRDELTALR] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRGLBLPROPS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRADDTLPROPS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRNODETYPES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRPROPDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRNODEDEFS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRRNODETYPES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRSUPERTYPES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTIMESTAMPS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRIDS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRDUMMY] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRMAXSNSIDX] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRGENDDL] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRINDEXNAMES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRINDEXES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSPENDING] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSERRORS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSINDEXES] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSPATHINFO] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSPOSCOR] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSNEGCOR] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRAPPL] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRNODEREGISTER] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSFULLCRAWLTOPICS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSSUBSCRIPTIONMANAGER] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSSEEDLISTPENDING] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRTSINCSUBSMSGS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCREDITIONINFO] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCREDITIONS] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRREMOVEHLP] TO [WP_JCR_RUNTIME_USERS];
GRANT SELECT, INSERT, UPDATE, DELETE ON OBJECT::[jcr].[ICMSTJCRIMPORTREF] TO [WP_JCR_RUNTIME_USERS];