RE: create User

> How can i create a new user??????
> 
> The answer of documentation:
> <create_user_statement> ::= CREATE USER <user_name> PASSWORD 
> <password>
[...]

CREATE USER is SQL-

> When i open a dbmcli session and type this command, the following 
> message appears:
> ERR
> -24977,ERR_COMMAND: unknown command "create_user"

dbmcli does not know of SQL, unless you use the _dbmcli_ command sql_execute.

> The docu ist not really useful !!

It has to be applied at the right place, SQL in an SQL session (SQL Studio, 
dbmcli SQL session, ...) dbmcli commands in a dbmcli session.
 
> By typing "help" the correct syntax appears:
> 
> user_create <username>,<pwd> [<templateuser>]   (needs dbname)

You mix up two different things.

> On which way i´ve to format the command?
> 
> user_create testuser,testpassword
> 
> unfortunately not enough! The answer of dbmcli:
> ERR
> -24948,ERR_NODBNAME: database name required

You must give dbmcli some hint which database instance you want to use. Use the 
-d commandline switch.
 
> Waht´s the correct syntax ???

usage: dbmcli [<options>] [[-c] <DBMServer-Command>]
    <options>:
        -u    username,passwd   (DBM user)
        -U    [userkey]         (default DBMUSR)
        -uUTL [username,passwd] (UTILITY session)
        -uSQL [username,passwd] (SQL session)
        -uSRV                   (Service session)
        -v                      (show version of server)
        -d    dbname            (set dbname)
        -R    dbroot            (set dbroot)
        -n    node              (name of servernode)
        -i    inputfile         (Default stdin)
        -o    outputfile        (Default stdout)
        -t    protocolfile      (writes subsequent protocol)
        -s                      (local mode, don't use with -n)
    <DBMServer-Command>:
        everything after the options will be sent to DBMServer


> Thkx!


HTH
Christian

-- 
#include <std_disclaimer.h> 
/* The opinions stated above are my own and not 
   necessarily those of my employer. */