Hello Ajit,
you and Thomnas wrote: > You may create a usergroup g and two users user1 and user2 as > members of that > group : > > CREATE USERGROUP G RESOURCE > CREATE USER USER1 PASSWORD USER1 USERGROUP G > CREATE USER USER2 PASSWORD USER2 USERGROUP G > > Both users have all privileges for all tables created by > any user of the usergroup. > I don't see another solution that makes tables created in the > future visible to both users. > > Thomas > > Hi Thomas, > I need to operate on the database in > SQLMODE=ORACLE.However the create usergroup G Resource > statement works only in internal mode. If I create the > usergroup in internal mode. I cannot work on the database in > OracleMode logging on as user1.The Mode selection gets > disabled in SQLstudio > setting.Any ideas? > Thanks > Ajit > You've run into a more general problem here : A user (or group) created with the 'exclusive' option (this is the default and applies in Thomas' example) can use at most one database connection. SQL Studio uses up this one connection if you open a direct SQL window (well, one is opened automatically after connect.). This connection will be reused even if you close the SQL window. One cannot change the sqlmode of a connection by means of special user commands when the connection is already established. That's the reason why change of sqlmode is not enabled in the settings dialog. You can't do other things as well in 'exclusive' mode, such as use the catalog view to create tables or establish 'autocommit off' sessions. summed up : SQL Studio does not support exclusive users very well. We could think about making the choice of sqlmode possible and implementing some sort of reconnect, or make the mode choosable before the connect in some way, but don't make much promises now. if possible, create your users/groups with option 'not exclusive' ; that's what people want anyway in most cases. sorry, Markus Stausberg SAP Labs Berlin > -----Original Message----- > From: ajit_cus [mailto:ajit_cus@;infosys.com] > Sent: Friday, October 11, 2002 7:47 AM > To: Anhaus, Thomas; [EMAIL PROTECTED] > Subject: RE: How do i grant one user access to all tables of another? > > > SQLSTUDIO has a setting where you can choose your query > mode(oracle/internal).When logging on to SQLstudio with a > user who belongs to a usergroup the selection of Sqlmode gets > disabled.(i.e. it is locked in internal mode).Thus I can no > longer execute any sqlmode oracle queries. > -Ajit > > -----Original Message----- > From: Anhaus, Thomas [mailto:thomas.anhaus@;sap.com] > Sent: Friday, October 11, 2002 11:10 AM > To: ajit_cus > Subject: RE: How do i grant one user access to all tables of another? > > Hi Ajit, > I'm not sure that I understood your problem. > However, it's true that usergroups and members can not be > created in oracle mode. > But it should be no problem to create them in internal mode and > then switch to oracle mode. > I had no problems to connect a group member in oracle mode, > what difficulties > did you had ? Please tell me which tool or programming > interface you used > and what error code has been returned. > Concerning SQLStudio I must tell you, that I don't know much > about it's > features and possibilities. As far as I know it's only > possible to connect > in sqlmode internal, but I'm not really sure. I will ask one of the > developers later and will inform you, if I'm wrong. > > Best Regard > Thomas > > -----Original Message----- > From: ajit_cus [mailto:ajit_cus@;infosys.com] > Sent: Freitag, 11. Oktober 2002 05:25 > To: Anhaus, Thomas; [EMAIL PROTECTED] > Subject: RE: How do i grant one user access to all tables of another? > > > Hi Thomas, > I need to operate on the database in > SQLMODE=ORACLE.However the create usergroup G Resource > statement works only in internal mode. If I create the > usergroup in internal mode. I cannot work on the database in > OracleMode logging on as user1.The Mode selection gets > disabled in SQLstudio > setting.Any ideas? > Thanks > Ajit > > You may create a usergroup g and two users user1 and user2 as > members of that > group : > > CREATE USERGROUP G RESOURCE > CREATE USER USER1 PASSWORD USER1 USERGROUP G > CREATE USER USER2 PASSWORD USER2 USERGROUP G > > Both users have all privileges for all tables created by > any user of the usergroup. > I don't see another solution that makes tables created in the > future visible to both users. > > Thomas > > -- > Thomas Anhaus > SAP DB, SAP Labs Berlin > [EMAIL PROTECTED] > http://www.sapdb.org/ > _______________________________________________ > 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
