Hi, passage taken from a mail from Thomas on this list: Use the NOT EXCLUSIVE option :
CREATE USER TEST PASSWORD TEST RESOURCE NOT EXCLUSIVE If the user already exists, the owner may grant MULTIPLE access : ALTER USER TEST NOT EXCLUSIVE Regards, Holger SAP Labs Berlin > -----Original Message----- > From: Mark Redding [mailto:[EMAIL PROTECTED]] > Sent: Dienstag, 13. November 2001 11:59 > To: [EMAIL PROTECTED] > Subject: Multiple Connections > > > When trying to use websql and xsql and SQLStudio I > receive the error > > # xsql -u ABUSE,ABUSE > > select * from counter > * -8022: User already connected > > exit > > Is it possible to enable multiple connections per > user, as I've both embedded sql in C and perl code > that may be executed at the same time ? > > > ===== > Mark W J Redding > > __________________________________________________ > Do You Yahoo!? > Everything you'll ever need on one web page from News and > Sport to Email and Music Charts > http://uk.my.yahoo.com >
