본문 바로가기

IT/SAP

Authorization for HANA Cockpit User

— create user DBACOCKPIT password Sap12345 NO FORCE_FIRST_PASSWORD_CHANGE;
— alter user DBACOCKPIT disable password lifetime;

 

— FOR SYSTEMDB Only
grant select on “SYS_DATABASES”.”M_SERVICES” to DBACOCKPIT;
grant select on “SYS_DATABASES”.”M_SERVICE_MEMORY” to DBACOCKPIT;
grant select on “SYS_DATABASES”.”M_SERVICE_STATISTICS” to DBACOCKPIT;
grant select on “SYS_DATABASES”.”M_HEAP_MEMORY_RESET” to DBACOCKPIT;

 

— FOR SYSTEMDB Only

grant select on “SYS”.”M_SERVICES” to DBACOCKPIT;
grant select on “SYS”.”M_SERVICE_MEMORY” to DBACOCKPIT;
grant select on “SYS”.”M_SERVICE_STATISTICS” to DBACOCKPIT;
grant select on “SYS”.”M_HEAP_MEMORY_RESET” to DBACOCKPIT;
grant select on “_SYS_STATISTICS”.”STATISTICS_SCHEDULE” to DBACOCKPIT;
grant select on “_SYS_STATISTICS”.”HELPER_ALERT_CHECK_INACTIVE_SERVICES_AGE” to DBACOCKPIT;
grant select on SCHEMA “_SYS_STATISTICS” to DBACOCKPIT;
grant “BACKUP ADMIN” to DBACOCKPIT;
grant “BACKUP OPERATOR” to DBACOCKPIT;
grant “CATALOG READ” to DBACOCKPIT;
grant “CERTIFICATE ADMIN” to DBACOCKPIT;
grant “DATABASE ADMIN” to DBACOCKPIT;
grant “INIFILE ADMIN” to DBACOCKPIT;
grant “LOG ADMIN” to DBACOCKPIT;
grant “MONITOR ADMIN” to DBACOCKPIT;
grant “ROLE ADMIN” to DBACOCKPIT;
grant “SESSION ADMIN” to DBACOCKPIT;
grant “SSL ADMIN” to DBACOCKPIT;
grant “TRACE ADMIN” to DBACOCKPIT;
grant “USER ADMIN” to DBACOCKPIT;
grant “ROLE ADMIN” to DBACOCKPIT;
grant select, delete on “_SYS_XS”.”JOB_SCHEDULES” to DBACOCKPIT;
grant select on “_SYS_XS”.”JOBS” to DBACOCKPIT;
grant “WORKLOAD ANALYZE ADMIN” to DBACOCKPIT;
grant “WORKLOAD CAPTURE ADMIN” to DBACOCKPIT;
grant “WORKLOAD REPLAY ADMIN” to DBACOCKPIT;

'IT > SAP' 카테고리의 다른 글

Post process(check), after implement Support Packages(JAVA)  (0) 2020.03.12
How to Connect MARIADB using SDA in SAP HANA  (0) 2020.03.12
Authorization for HANA Cockpit User  (0) 2020.03.12
CTS File Download Report  (0) 2019.09.03
Exam PRODS4PRESALES  (0) 2019.01.09
SAP CTS UPLOAD  (0) 2018.11.15