GRANT
SAP_CAR_SELECT_USER
TO RDS_RETAIL_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT RDS_PA_PAL_ADMIN TO RDS_RETAIL_PA_BI_ADMIN WITH ADMIN OPTION;
h)
Telco (Industry)
CREATE
SCHEMA
SAP_RDS_PA_TELCO;
GRANT CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_TELCO 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
;
-- Role for setting up SAP HANA content modeling
CREATE ROLE RDS_TELCO_PA_BI_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN to RDS_TELCO_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT SELECT ON SCHEMA SAP_RDS_PA_TELCO TO RDS_TELCO_PA_BI_ADMIN WITH
GRANT OPTION;
-- Role for setting up algorithm using PA tool
CREATE
ROLE RDS_TELCO_PA_ADMIN;
GRANT
RDS_PA_PAL_ADMIN
TO
RDS_TELCO_PA_ADMIN
WITH
ADMIN
OPTION
;
GRANT
RDS_PA_DATA_ADMIN
TO
RDS_TELCO_PA_ADMIN
WITH
ADMIN
OPTION
;
GRANT
RDS_TELCO_PA_BI_ADMIN
TO
RDS_TELCO_PA_ADMIN
WITH
ADMIN
OPTION
;
