Skip to Content
Former Member
May 28, 2020 at 01:10 PM

MAXDB creating user : whats the difference between dbmcli and sqlcli

931 Views Last edit May 28, 2020 at 01:49 PM 2 rev

Hello MAX DB Gurus,

i got one questions about the usermanagement in MAXDB. When we create a new DB User with dbmcli with following command "user_create <user>,<password>" we can not find the user in the MAXDB Studio under the point "Users". There we can only the see the standardusers SUPERDBA,CONTROL, SAPSID. Why we can not see the created user with dbmcli under this section? Also when we use the following statement "sql_execute SELECT owner, username FROM DOMAIN.USERS" there is the created user missing :((

Nevertheless we can logon with the new created user via dbmcli, so it is a little confusing why we can not see the newly created user in MAXDB Studio.

thank you in advance