CTS FWR5-3105SFP-CW-AC-DR Series, Manual

Page: 88 / 90

--PA Content Admin
CREATE ROLE RDS_PA_CONTENT_ADMIN ;
GRANT IMPORT , EXPORT , CONTENT_ADMIN, MODELING to RDS_PA_CONTENT_ADMIN WITH
ADMIN OPTION ;
--PA Pal Admin
CREATE ROLE RDS_PA_PAL_ADMIN ;
-- Grant afl execute to PAL Admin
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 ;
-- Role for setting up hana content modeling
CREATE ROLE RDS_BANK_PA_BI_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN to RDS_BANK_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT SELECT ON SCHEMA SAP_RDS_PA_BANK TO RDS_BANK_PA_BI_ADMIN WITH GRANT
OPTION;
-- Role for setting up algorithm using PA tool
CREATE ROLE RDS_BANK_PA_ADMIN ;
GRANT RDS_PA_PAL_ADMIN TO RDS_BANK_PA_ADMIN WITH ADMIN OPTION ;
GRANT RDS_PA_DATA_ADMIN TO RDS_BANK_PA_ADMIN WITH ADMIN OPTION ;
GRANT RDS_BANK_PA_BI_ADMIN TO RDS_BANK_PA_ADMIN WITH ADMIN OPTION ;
GRANT SELECT ON SCHEMA SAP_RDS_PA_BANK TO _SYS_REPO WITH GRANT OPTION ;
f) Consumer Products (Industry)
CREATE
SCHEMA SAP_RDS_PA_CPG;
GRANT CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_CPG TO _SYS_REPO WITH GRANT OPTION;
GRANT SELECT ON SCHEMA <DSIM_DOMAIN> TO _SYS_REPO WITH GRANT OPTION;
--PA Content Admin
CREATE ROLE RDS_PA_CONTENT_ADMIN;
GRANT IMPORT , EXPORT , CONTENT_ADMIN, MODELING to RDS_PA_CONTENT_ADMIN WITH
ADMIN OPTION ;
--PA Pal Admin
CREATE ROLE RDS_PA_PAL_ADMIN;
-- Grant afl execute to PAL Admin
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 ;