GRC Access Control 12.0 ARM setup for provisioning HANA DB users

Let’s first go over an example of a HANA DB role request and then show that role provisioned in HANA DB through GRC Access Control.  First screenshot below is an access request for HANA DB role ABAP_ADMIN. Once the request is submitted and goes through the approvals, the role gets assigned to user ID.  The second screenshot shows the assignment in HANA DB.

Demystifying SAP HANA Administration

Since its release, SAP HANA represented a radical change in the direction of SAP's product architecture. As an SAP Instructor, I’ve been wondering how easy it would be to manage the new SAP HANA platform. Can I use platform and administration tools that are currently in place? Or, do I need to learn a new set of gadgets?

After reading through some of the documentation available in SAP Learning Hub, and reviewing SAP courses such as SAP HANA Introduction (HA100), SAP HANA - Operations & Administration (HA200), and SAP HANA Implementation and Modeling (HA300), I realized that the learning curve is quite easy – if you get some guidance up-front. That’s why I’m here! This blog will demystify SAP HANA administration by listing tools you can use to handle periodic administrative tasks, and by explaining the key capabilities of each and when to use them.

Reset the SYSTEM User's Password in HANA DB

Overview
If the SYSTEM user's password is lost, you can reset it as the operating system administrator by starting the index server in emergency mode. If your HANA DB is Multitenant, this process will not work.  My HANA DB revision was 102.04

Prerequisites
You have the credentials of the operating system administrator (<sid>adm).

Procedure
Step 1: Log on to the server on which the master index server is running as the operating system user (that is, <sid>adm user).

Step 2: Open a command line interface.

Step 3: Shut down the instance by executing the following command:
/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB