Hi all, again to remember:
There are dbm operators and there are database users. Apparently Zsolt and Marcus wanted to create the second one (a database user)- A dbm operator (generally, one who can execute all these fine dbmcli command, and utilise DBMGUI to monitor the database, make backups, etc. can be create with that user_create command: http://www.sapdb.org/7.4/htmhelp/29/4e6939474e11d4aa1100a0c9430730/content.htm In contrast, a database user is create using the SQL statement CREATE USER: http://www.sapdb.org/7.4/htmhelp/48/f0daa5225811d3a97d00a0c9449261/content.htm If you want to execute a SQL command from dbmcli, you have to prefix it with sql_execute: http://www.sapdb.org/7.4/htmhelp/fd/9a05e4613411d4aa1500a0c9430730/content.htm You can of course issue the CREATE USER statement not only from dbmcli, but also from SQL Studio, for instance. Regards Alexander Schr�der SAP Labs Berlin > -----Original Message----- > From: Andreas Ernst [mailto:[EMAIL PROTECTED]] > Sent: Thursday, February 13, 2003 3:13 PM > To: Marcus Berglund <[EMAIL PROTECTED]>; SAPDB > Subject: Re: Newbie question: creating a user > > > Hi, > > try: > > [sapdb@nerdling sapdb]$ dbmcli -u dbm,dbm -d soprano > > > help > > and you get all commands.... > > and at the end ot the list > > user_create > > HTH > Andreas > > Marcus Berglund schrieb: > > >I have the same problem. The problem for me is not the syntax of the > >command but how to execute it. When using the dbmcli I get this: > > > >[sapdb@nerdling sapdb]$ dbmcli -u dbm,dbm -d soprano > >dbmcli on soprano>create user testuser password pwd not exclusive > >ERR > >-24977,ERR_COMMAND: unknown command "create" > > > >I guess Im not supposed to use the dbmcli for this - but what am I > >supposed to use to get a regular SQL session going with my db?? > >Would appreciate some help.. > > > > > >--- > > > >--- In [EMAIL PROTECTED], "Zabach, Elke" > ><[EMAIL PROTECTED]> wrote: > > > > > >>Zsolt Almasi wrote: > >> > >> > >> > >>>Can you tell me , how can I create a Standard user ? I will > >>>apreciate if you > >>>can show me some examples ! > >>> > >>> > >>the reference-manual is too complicate to understand this? > >>(see chapter Authorization --> create user ) > >> > >> > >> > >http://www.sapdb.org/htmhelp/48/f0daa5225811d3a97d00a0c944926 1/frameset.htm > > >>example >>create user xyz password abc >> >>Elke >>SAP Labs Berlin >>_______________________________________________ >>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 > > > _______________________________________________ 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
