b)
Manufacturing (Line of Business)
CREATE SCHEMA SAP_RDS_PA_MFG;
GRANT CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_MFG TO _SYS_REPO WITH GRANT OPTION;
--- PA Content
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;
-- Note this is tied to the SLT Schema and have to append
-- _SELECT USER and grant to admin role
GRANT
RDS_SAP_ERP_PA_POWER_USER
TO RDS_PA_DATA_ADMIN with ADMIN OPTION;
GRANT
RDS_SAP_ERP_PA_SELECT_USER
TO _SYS_REPO with ADMIN OPTION;
-- Note this is tied to the HANA Live Schema and have to append
-- _SELECT USER and grant to admin role
GRANT
SAP_ECC_POWER_USER
TO RDS_PA_DATA_ADMIN with ADMIN OPTION;
GRANT
SAP_ECC_SELECT_USER
TO _SYS_REPO with ADMIN OPTION;
CREATE ROLE RDS_MFG_PA_POWER_USER;
GRANT CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_MFG to RDS_MFG_PA_POWER_USER WITH GRANT OPTION;
GRANT RDS_MFG_PA_POWER_USER TO _SYS_REPO WITH ADMIN OPTION;
CREATE ROLE RDS_MFG_PA_SELECT_USER;
GRANT SELECT ON SCHEMA SAP_RDS_PA_MFG TO RDS_MFG_PA_SELECT_USER WITH
GRANT OPTION;
CREATE ROLE RDS_MFG_PA_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN TO RDS_MFG_PA_ADMIN WITH ADMIN OPTION;
-- Append _SELECT_USER to SLT sourced schema and grant to admin role
-- DATA ADMIN
GRANT RDS_PA_CONTENT_ADMIN TO RDS_MFG_PA_ADMIN WITH ADMIN OPTION;
GRANT RDS_PA_DATA_ADMIN TO RDS_MFG_PA_ADMIN WITH ADMIN OPTION;
GRANT RDS_MFG_PA_POWER_USER TO RDS_MFG_PA_ADMIN WITH ADMIN OPTION;
--- PAL Parameter Controller Role
