HANA Cloud (Trial): Manual Schema error in sql create user

[davy_veilleux]

Hi,

I'm learning SAP Hana Cloud and Database Explorer (in Web IDE) following carefully SAP Hana Academy on Youtube. It's a great resource in general, but the line between limtations of Trial account and regular cloud accound is sometimes blury. I have a simple HDI database defined in my database explorer. In video "HANA Cloud: Manual Schema"

https://www.youtube.com/watch?v=waTp-Q0Xkdc&list=PLkzo92owKnVzONfsNdQNmpPQvUT54UUAL∈dex=4

As mentionned in the video, I try to create manually a scema with that SQL Line.

CREATE USER devuser PASSWORD Password1 NO FORCE_FIRST_PASSWORD_CHANGE SET USERGROUP DEFAULT;

I keep getting this error:

(dberror) [702]: invalid usergroup name: DEFAULT

if I remove "SET USERGROUP DEFAULT", my error become

(dberror) [258]: insufficient privilege

Any idea what do I missing to make it through? Seems to be an authorisation issue.

Thanks

Davy

[dvankempen]

You asked a question. Don't forget to mark the answer that helped you most as correct. Thanks!

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too. Thanks.

[dvankempen]

Thanks vitaliy.rudnytskiy, that's correct.

Hi Davy,

On the SCP trial account, you get a schema and an HDI container on a shared database.

SELECT * FROM m_database;

You share the database with 10K other users.

SELECT COUNT(USER_NAME) FROM USERS;

This is your user

SELECT * FROM USERS WHERE USER_NAME = (SELECT CURRENT_USER FROM DUMMY);

You can connect to the HDI container (schema) but your (trial) user does not have USER ADMIN privileges on the database to create new users (or to create user groups), hence the error when you execute CREATE USER or CREATE USERGROUP

FYI ===>

On the production | customer landscape, the SAP HANA Cloud instance is a complete tenant database (not only an HDI container).

The administration account is DBADMIN, which is identical to the SYSTEM user except for one system privilege: USER ADMIN.

DBADMIN is a USER ADMIN for the DEFAULT user group but not for the tenant database as a whole. This way, important technical accounts cannot be tampered with causing certain functionality to break.

This is why on the HANA Cloud database we need to append USERGROUP DEFAULT to the CREATE USER statement (as shown in Philip's video).

[davy_veilleux]

Ahhhhh, that explain everything!!! So you two guys just cleared out a big confusion I had. Working with my own trial SAP Cloud Platform does not mean that I work on my own Hana system in Web IDE and Database Explorer. It's shared with the 10k users with a Trial account, so you are limited in what you can do... it makes sense.

I think that I heard Philip saying in a video that Hana would become available in Trial later on this year, is that right? Else I will work with my Google Cloud Platform account where I can create schema and users in Database Explorer.

Thanks a lot Witalij and Denys.

Best Regards,

Davy

[Vitaliy-R]

Hi Davy. SAP HANA Cloud does not have a Trial version available yet. To follow these HANA Academy videos you need to have access to the account in Production with the SAP HANA Cloud entitlement.

[dvankempen]

You are most welcome, Davy

There is probably going to be a trial in one form or another. Have not seen anything in print yet. Work-in-progress. Follow the tag #saphana and you will be notified.

==

Don't forget to select a correct answer. This helps other people's search. Thx.

+++++++

Update: the SAP HANA Cloud trial versions was made available with the QRC (quarterly release cycle) of June 2020.

One of the features is that the USERGROUP no longer needs to be defined when the default usergroup is used, cf.

https://blogs.sap.com/2020/09/03/whats-new-sap-hana-cloud-qrc-02-2020/

[rajakaturi]

The trail version is allowing to create the user.