Thanks for the quick response! I managed to create a user using the dbmcli command (create_user user,password). However, from your response I noticed that this was not the way I should have done (thanks again) it as I just want to create a regular user that can connect to the db (the goal is for that user to be able to use jdbc to access the database). So trying out the second alternative:
[sapdb@nerdling sapdb]$ dbmcli -u dbm,dbm -d soprano dbmcli on soprano>sql_execute CREATE USER bcuser PASSWORD bcpass ERR -24988,ERR_SQL: sql error -5001,Missing privilege:DBA Ok - to minimize the risk of idiot-errors: - Am I wrong in thinking that the user dbm really is a dbm? How do I get sql access ? what username should I use with the dbmcli ? Should I use the username,password I used when installing sapdb? I used uid:sapdb,gid:sapsys but I get a user authorization failure when trying to run dbmcli using it). I tried finding some relevant information here (couldnt find the relevant info in the official online docs) : http://www.rst-consult.com/database/sapdb/dbmcli_us_html.html#0.2.3.3.3CreatingandchangingdatabaseusersinTST|outline but the output from the "dbmcli -n localhost -d soprano -u dbm,dbm user_get dbm"-command does not look the output I'm getting. This is what I get: dbmcli on localhost : soprano>user_get dbm OK SERVERRIGHTS=DBInfoRead,ExecLoad,UserMgm,DBFileRead,Backup,InstallMgm,LoadSysTab,ParamCheckWrite,ParamFull,ParamRead,DBStart,DBStop,Recovery,AccessSQL,AccessUtility GUIRIGHTS= SECONDPASSWORD=NO DISABLED=NO COMMENT= I use Linux and as far as I can tell there is no "SQLStudio" available for download. I feel that these are extremely basic questions but I just cant seem to find any relevant information that works for me (the commands I try from the docs on the rst-consult website just gives me errors and I just cant seem to find any relevant info in the sapdb online docs.). Have I missed some basic howto that deals with this? I've sofar checked out these links (apart from the sap online docs): http://www.mybytes.de/sapdb/ http://www.rst-consult.com/database/sapdb/odbc_us/index.html I would really appreciate a pointer in the right direction.. Cheers, /m On Thu, 13 Feb 2003 15:31:23 +0100, Schroeder, Alexander wrote: > 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
