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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]] 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
