Skip to content

Database transfer: Download the script and grant permissions for the MS SQL 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.

    db2 -tvf SetupDB2Database.sql

    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];