GRANT
CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX
ON
SCHEMA SAP_RDS_PA_CRM TO _SYS_REPO WITH GRANT OPTION;
-- Establish referenced tables for DU onboarding
CREATE column table SAP_RDS_PA_CRM.SALESORG_ANALYSIS_PDATA_T ("ID"
INT,"TYPENAME" VARCHAR(100),"DIRECTION" VARCHAR(100));
--- PAL Content Admin
CREATE ROLE RDS_PA_CONTENT_ADMIN;
GRANT IMPORT, EXPORT, CONTENT_ADMIN, MODELING to RDS_PA_CONTENT_ADMIN WITH
ADMIN OPTION;
--- PAL Admin
CREATE ROLE RDS_PA_PAL_ADMIN;
-- Grant afl execute
GRANT AFL__SYS_AFL_AFLPAL_EXECUTE TO RDS_PA_PAL_ADMIN WITH ADMIN OPTION;
GRANT AFL__SYS_AFL_AFLBFL_EXECUTE TO RDS_PA_PAL_ADMIN WITH ADMIN OPTION;
GRANT CREATE R SCRIPT TO RDS_PA_PAL_ADMIN WITH ADMIN OPTION;
-- Role for setting up algorithm using PA tool
CREATE ROLE RDS_PA_DATA_ADMIN;
GRANT DATA ADMIN to RDS_PA_DATA_ADMIN WITH ADMIN OPTION;
CREATE ROLE RDS_CRM_PA_POWER_USER;
GRANT CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_CRM to RDS_CRM_PA_POWER_USER WITH GRANT OPTION;
GRANT RDS_CRM_PA_POWER_USER TO _SYS_REPO WITH ADMIN OPTION;
CREATE ROLE RDS_CRM_PA_SELECT_USER;
GRANT SELECT ON SCHEMA SAP_RDS_PA_CRM TO RDS_CRM_PA_SELECT_USER WITH
GRANT OPTION;
CREATE ROLE RDS_CRM_PA_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN TO RDS_CRM_PA_ADMIN WITH ADMIN OPTION;
-- append _SELECT_USER to SLT sourced schema and grant to admin role
GRANT
SAP_ERP_V4_POWER_USER
TO RDS_CRM_PA_ADMIN with ADMIN OPTION;
GRANT
SAP_ERP_V4_SELECT_USER
TO _SYS_REPO with ADMIN OPTION;
-- DATA ADMIN
GRANT RDS_PA_CONTENT_ADMIN TO RDS_CRM_PA_ADMIN WITH ADMIN OPTION;
GRANT RDS_CRM_PA_POWER_USER TO RDS_CRM_PA_ADMIN WITH ADMIN OPTION;
GRANT RDS_PA_DATA_ADMIN TO RDS_CRM_PA_ADMIN WITH ADMIN OPTION;
--- PAL Parameter Controller Role
CREATE ROLE RDS_CRM_PAL_PARAMETER_CONTROLLER;
GRANT SELECT, UPDATE, DELETE ON SCHEMA SAP_RDS_PA_CRM TO
RDS_CRM_PAL_PARAMETER_CONTROLLER WITH GRANT OPTION;
-- BI Admin Role
CREATE ROLE RDS_CRM_PA_BI_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN to RDS_CRM_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT RDS_CRM_PA_SELECT_USER TO RDS_CRM_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT RDS_PA_PAL_ADMIN TO RDS_CRM_PA_BI_ADMIN WITH ADMIN OPTION;
