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

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