-
Connect as an administrator, eg.
DBAdmin
user in the command below.hdbsql -u DBAdmin -n <yourinstanceSQLendpointhost>:<yourinstanceSQLendpointport>
-
Switch the input to multiline SQL statements separated with
;
by default.\multiline ON
-
Execute SQL statement to create a user
DEVCHALLENGER
(with a passwordUp2TheChallenge!Iam
in the example below).CREATE USER DevChallenger PASSWORD "Up2TheChallenge!Iam" --replace this with your password of choice! NO FORCE_FIRST_PASSWORD_CHANGE;
-
Execute SQL statement to grant a role
AFL__SYS_AFL_AFLPAL_EXECUTE
to the userDEVCHALLENGER
.GRANT AFL__SYS_AFL_AFLPAL_EXECUTE TO DevChallenger;
-
Optionally, check that the user record has been added to the
USERS
system table.SELECT COUNT(*) FROM USERS WHERE USER_NAME='DEVCHALLENGER';
-
Quit
hdbsql
utility.\quit