CTS FWR5-3105SFP-CW-AC-DR Series, Руководство пользователя

Страница: 86 / 90

CREATE ROLE RDS_MFG_PAL_PARAMETER_CONTROLLER;
GRANT SELECT, UPDATE, DELETE ON SCHEMA SAP_RDS_PA_MFG TO
RDS_MFG_PAL_PARAMETER_CONTROLLER WITH GRANT OPTION;
-- BI Admin Role
CREATE ROLE RDS_MFG_PA_BI_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN to RDS_MFG_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT RDS_PA_PAL_ADMIN TO RDS_MFG_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT RDS_MFG_PA_SELECT_USER TO RDS_MFG_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT
RDS_SAP_ERP_PA_SELECT_USER TO RDS_MFG_PA_BI_ADMIN WITH ADMIN OPTION;
GRANT SAP_ECC_SELECT_USER TO RDS_MFG_PA_BI_ADMIN WITH ADMIN OPTION;
c) Finance (Line of Business)
CREATE SCHEMA SAP_RDS_PA_FIN;
GRANT CREATE ANY , ALTER , DROP , EXECUTE , SELECT , INSERT , UPDATE , DELETE , INDEX ON
SCHEMA SAP_RDS_PA_FIN 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 ;
--- PAL Parameter Controller Role
CREATE ROLE RDS_FIN_PAL_PARAMETER_CONTROLLER;
GRANT SELECT, UPDATE, DELETE ON SCHEMA SAP_RDS_PA_FIN TO
RDS_FIN_PAL_PARAMETER_CONTROLLER WITH GRANT OPTION;
-- Role for setting up hana content modeling
CREATE ROLE RDS_FIN_PA_BI_ADMIN;
GRANT RDS_PA_CONTENT_ADMIN to RDS_FIN_PA_BI_ADMIN WITH ADMIN OPTION ;
GRANT SELECT ON SCHEMA SAP_RDS_PA_FIN TO RDS_FIN_PA_BI_ADMIN WITH GRANT
OPTION ;
-- Role for setting up algorithm using PA tool
CREATE ROLE RDS_FIN_PA_ADMIN;
GRANT RDS_PA_PAL_ADMIN TO RDS_FIN_PA_ADMIN WITH ADMIN OPTION ;
GRANT RDS_PA_DATA_ADMIN TO RDS_FIN_PA_ADMIN WITH ADMIN OPTION ;
-- <HANA_LIVE_SCHEMA> refers to the schema managed by the SAP LT
-- process, and is the underlying schema for HANA Live views.