> 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. */
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
