Hello, On Freitag, 10. Januar 2003 20:33, Martin Cordova S. wrote: > In SAPDB, each database is a service, so I wonder how should I parcel my > sets of tables (schemas), since I no longer have the database concept in > the way that SQLServer uses it. I know that SAPDB 7.4 does not have schemas > (right?), and I read somewhere in the SAPDB docs that it is not recommended > to have more than one database instance per server, so my question is: > Should I use the User as the schema equivalent, and create tables for > different businesses using a different user for each "business". I want to > use a single database instance to store tables for different (and > unrelated) applications, but I don't have a clear picture about how to > create a boundary between these tables. > the sapdb user concept enables you to have distinct schemas. It is by far not as sophisticated as the db2 schema concept, but there is enough functionality to have private tables and tables that can be accessed by other users.
Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
