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
