True which is why I said 'for me', we all have different priorities :-) What I'm trying to do is simulate an Informix database concept in SAPDB. On Informix one database instance can handle multiple databases. Databases are in effect a container for all the various database objects (tables, indexes, views etc).
So database 'live' could contain tables a,b,c,e, and f and database 'test' could contain tables a,e,f and x. In effect, users connect to the database server using their userid and can then access different databases (security permitting). Any unqualified objects (Informix supports [database@dbserver:]tablename syntax) are relative to the current database. Some of our Informix database instances hold several hundred databases. So from my reading of SAPDB, usergroups seem to be out since 1 user can only belong to 1 group? This seems to leave me with creating a dummy user to represent a 'database' and therefore own all the objects, but then all users would have to connect to that 'database' as the same dummy user, meaning I could no longer differentiate them at a connection level? In Oracle 8i/9i I have to use the same dummy user concept, but Oracle includes an "ALTER SESSION SET CURRENT_SCHEMA = xyz" command, which allows me to connect to the instance using the correct userid. However if an ASSCS = xyz command is issued all unqualified references are relative to xyz and not the userid used to connect to the instance. This provides me with the 'database' container mechanism I'm looking for. Does that make sense or am I missing something fundamental? Regards, David -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 15 October 2002 18:41 To: David N. Heydon Cc: '[EMAIL PROTECTED]' Subject: RE: Adding multi-schema support to SAPDB David, >Seriously though, this seems to be the only big missing >functionality for me in SAPDB compared to >Informix (DATABASE) and Oracle or DB/2 (Schema). Unfortunately 'the the only big missing functionality' seems to be different for everybody. Seriously, what is that doesn fit into the user/usergroup approach? Regards, Wojtek _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
