As shown in http://www.sapdb.org/7.4/htmhelp/48/f0daa5225811d3a97d00a0c9449261/content.htm
the key is to create the user as NOT EXCLUSIVE, to allow him to create more than one session. You may also modify existing user using the ALTER USER command, e.g. ALTER USER SCOTT NON EXCLUSIVE (See http://www.sapdb.org/7.4/htmhelp/48/f0dab1225811d3a97d00a0c9449261/content.htm) For what you want to do with GRANT, the user group is used in those command. So ALTER USER SCOTT DBA would make SCOTT to a DBA. GRANT manages the rights on individual database objects (tables, procedures, ...) and the rights of the user on these (SELECT, INSERT, UPDATE ...). Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Vishal Kant [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 11, 2003 2:26 PM > To: [EMAIL PROTECTED] > Subject: Grant user > > > Hi, > > > I am facing a problem in SAP DB. I want to login into the > database with multiple session with the same user name. Only > DBA can access multiple session. > I tried the command "Create user "user_name" password > "password" DBA. But I am not able to have multiple sessions > in SQL studio. The message I get is user already connected. > And I am not able to excecute the command > GRANT USER <Granted User> from <User Name> to <User Name> > > for eg I want to give DBA prevelidges to a user vk, what will > be the command > > regards > > Vishaal Kant > Kale Consultants Ltd. > Enterprise Software Solutions > Telephone +91 22 28259580 Ext. 322 > http://www.kaleconsultants.com > > > Disclaimer: > This e-mail may contain Privileged/Confidential information and is > intended only for the individual(s) named. Please notify the > sender, if > you have received this e-mail by mistake and delete it from > your system. > Information in this message that do not relate to the > official business of > the company shall be understood as neither given nor endorsed by it. > E-mail transmission cannot be guaranteed to be secure or > error-free. The > sender does not accept liability for any errors or omissions in the > contents of this message which arise as a result of e-mail > transmission. > If verification is required please request a hard-copy version. > Visit us at www.kaleconsultants.com > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
