It is always safe to create a development user and even make a copy of the SYSTEM user to use as an administrator in case you somehow lock yourself out.
In a new SSH console, switch to the user hxeadm
and connect to the database as follows:
sudo su - hxeadm
hdbsql -i 90 -d SYSTEMDB -u SYSTEM
Enter the master password you chose at setup. When the hdbsql
command prompt is ready, enter the following (replacing a the password and username for one of your choice):
CREATE USER WORKSHOP_01 PASSWORD <password> NO FORCE_FIRST_PASSWORD_CHANGE ;
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::EditorDeveloper','WORKSHOP_01');
CALL GRANT_ACTIVATED_ROLE ('sap.hana.ide.roles::CatalogDeveloper','WORKSHOP_01');
Note: You may need to add additional roles or permissions depending on your development needs