Customize SAP HANA User Parameter Keys

You can customize a subset of SAP HANA user parameter keys when you install or upgrade SAP Agile Data Preparation.

SAP Agile Data Preparation stores user information as SAP HANA user parameters. For example, the following statement sets the first name to Mary for user Mary:

ALTER USER MARY SET PARAMETER ‘sap.hana.im.adp.firstname’ = ‘Mary’;
You can change the key of the following SAP HANA user parameters:
Parameter Key

Purpose

sap.hana.im.adp.firstname

Tracks the first name of the user

sap.hana.im.adp.lastname

Tracks the last name of the user

EMAIL ADDRESS

Tracks the email address of the user
  1. If you have not already downloaded and deployed the delivery unit for SAP Agile Data Preparation Version 1.0 SP 13, perform the following steps:
    1. Download SAP Agile Data Preparation Delivery Unit.
    2. Deploy the Delivery Unit from SAP HANA Studio or Deploy the Delivery Unit from SAP Life Cycle Management
  2. If you are upgrading from a previous version of SAP Agile Data Preparation, perform the following steps:
    1. Upgrade to SAP Agile Data Preparation Version 1.0 SP 14
    2. Migrate the non-customizable SAP HANA user parameters by running the following scripts on the SQL Console of SAP HANA studio:

      CALL "_SYS_REPO"."GRANT_ACTIVATED_ROLE"( 'sap.hana.im.adp.db.roles::Administrator', ‘<CURRENT_HANA_USER_NAME>’);

      CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.db.procedures::migrateUserParameters";

      CALL "_SYS_REPO"."REVOKE_ACTIVATED_ROLE"( 'sap.hana.im.adp.db.roles::Administrator', ‘<CURRENT_HANA_USER_NAME>’);

      The following non-customizable SAP HANA user parameters are migrated to the database table "SAP_HANA_IM_ADP"."sap.hana.im.adp.db::ADMIN.APP_USERS":
      Parameter Key

      Purpose

      sap.hana.im.adp.importeduser

      When this value is set to 1, the user is tagged as an SAP Agile Data Preparation user who was imported from an SAP HANA user.

      sap.hana.im.adp.diskquota

      Tracks the disk quota allocated to the user.

      sap.hana.im.adp.last_view_version

      Tracks the last version of the product used by the user.

      sap.hana.im.adp.whatsnew_version

      Tracks the last version of the product whose What’s New page is viewed by the user.
  3. Ensure that no users are currently using SAP Agile Data Preparation.
  4. Change the customizable SAP HANA user parameter keys by running the following script on the SQL Console of SAP HANA studio:

    CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.db.procedures::setUserParameterNames"( <FIRSTNAME_KEY>, <LASTNAME_KEY>, <EMAIL_KEY>); 

    CALL "SAP_HANA_IM_ADP"."sap.hana.im.adp.db.procedures::setUserParameterNames" 
('sample.firstname', 'sample.lastname', 'EMAIL');