Skip to content

Latest commit

 

History

History
37 lines (29 loc) · 1.13 KB

File metadata and controls

37 lines (29 loc) · 1.13 KB

Create DEVCHALLENGER user in your SAP HANA db instance in SAP HANA Cloud Trial

... using hdbsql

  1. Connect as an administrator, eg. DBAdmin user in the command below.

    hdbsql -u DBAdmin -n <yourinstanceSQLendpointhost>:<yourinstanceSQLendpointport>
  2. Switch the input to multiline SQL statements separated with ; by default.

    \multiline ON
  3. Execute SQL statement to create a user DEVCHALLENGER (with a password Up2TheChallenge!Iam in the example below).

    CREATE USER DevChallenger 
    PASSWORD "Up2TheChallenge!Iam" --replace this with your password of choice!
    NO FORCE_FIRST_PASSWORD_CHANGE;
  4. Execute SQL statement to grant a role AFL__SYS_AFL_AFLPAL_EXECUTE to the user DEVCHALLENGER.

    GRANT AFL__SYS_AFL_AFLPAL_EXECUTE TO DevChallenger;
  5. Optionally, check that the user record has been added to the USERS system table.

    SELECT COUNT(*) FROM USERS WHERE USER_NAME='DEVCHALLENGER';
  6. Quit hdbsql utility.

    \quit

Create a DB user called DEVCHALLENGER