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;