GRANT
<HANA_LIVE_SCHEMA>_POWER_USER
TO
RDS_FIN_PA_ADMIN
with
ADMIN
OPTION
;
GRANT
RDS_FIN_PA_BI_ADMIN
TO
RDS_FIN_PA_ADMIN
WITH
ADMIN
OPTION
;
GRANT
SELECT
ON
SCHEMA
SAP_RDS_PA_FIN
TO
_SYS_REPO
WITH
GRANT
OPTION
;
GRANT
<HANA_LIVE_SCHEMA>_SELECT_USER
TO
_SYS_REPO
with
ADMIN
OPTION
;
d)
Portfolio & Project Management (Line of Business)
CREATE
SCHEMA
SAP_RDS_PA_PPM
;
GRANT
CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_PPM 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
AFL__SYS_AFL_APL_AREA_EXECUTE TO RDS_PA_PAL_ADMIN WITH ADMIN OPTION;
GRANT
AFLPM_CREATOR_ERASER_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 PAL Parameter Controller
CREATE ROLE RDS_PPM_PAL_PARAMETER_CONTROLLER;
GRANT SELECT, UPDATE, DELETE ON SCHEMA SAP_RDS_PA_PPM TO
RDS_PPM_PAL_PARAMETER_CONTROLLER WITH GRANT OPTION;
-- Role for setting up hana content modeling
CREATE ROLE RDS_PPM_PA_BI_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN to RDS_PPM_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT SELECT ON SCHEMA SAP_RDS_PA_PPM TO RDS_PPM_PA_BI_ADMIN WITH GRANT
OPTION;
-- Role for setting up algorithm using PA tool
CREATE
ROLE RDS_PPM_PA_ADMIN
;
GRANT
RDS_PA_PAL_ADMIN
TO
RDS_PPM_PA_ADMIN
WITH
ADMIN
OPTION
;
GRANT
RDS_PA_DATA_ADMIN
TO
RDS_PPM_PA_ADMIN
WITH
ADMIN
OPTION
;
GRANT
RDS_PPM_PA_BI_ADMIN
TO
RDS_PPM_PA_ADMIN
WITH
ADMIN
OPTION
;
GRANT
SELECT
ON
SCHEMA
SAP_RDS_PA_PPM
TO
_SYS_REPO
WITH
GRANT
OPTION
;
e)
Banking (Industry)
CREATE
SCHEMA
SAP_RDS_PA_BANK
;
GRANT
CREATE ANY, ALTER, DROP, EXECUTE, SELECT, INSERT, UPDATE, DELETE, INDEX ON
SCHEMA SAP_RDS_PA_BANK TO _SYS_REPO WITH GRANT OPTION;
