J�rg Helmrich wrote: > > How can i create a new user?????? > > The answer of documentation: > <create_user_statement> ::= CREATE USER <user_name> PASSWORD > <password> > [<user_mode>] [PERMLIMIT <unsigned_integer>] [TEMPLIMIT > <unsigned_integer>] > [TIMEOUT <unsigned_integer>] [COSTWARNING <unsigned_integer>] > [COSTLIMIT <unsigned_integer>] [[NOT] EXCLUSIVE] > | CREATE USER <user_name> PASSWORD <password> LIKE <source_user> > | CREATE USER <user_name> PASSWORD <password> USERGROUP > <usergroup_name> > > When i open a dbmcli session and type this command, the following > message appears: > ERR > -24977,ERR_COMMAND: unknown command "create_user" > > The docu ist not really useful !!
The reference manual mentioned above gives the correct syntax of the sql-statement. Depending on the tools you are using, some added info has taken into account. And the dbmcli-manual tells you, that sql_execute has to be put in front of each sql-statement sent. Perhaps you should check the manual of dbmcli? Elke SAP Labs Berlin > > By typing "help" the correct syntax appears: > > user_create <username>,<pwd> [<templateuser>] (needs dbname) > > OK. > > 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 > > Waht�s the correct syntax ??? > > Thkx! > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
