Skip to Content
1
Apr 08, 2020 at 01:32 AM

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

396 Views

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