Hi, > Hello, > > I'm porting a database application from postgres to sapdb. For every > customer there is a different database with postgres. > > Doing it this way with sapdb seems to be no good choice because of the > overhead for each database instance. I found an entry in the mailing > list from someone with a simular problem. He says that he hab created > only one database instance with a different user for each customer DB. > Because of the different name spaces of each user the tables don't > collide. > > So I created a database user for the first Database with a create user > statement. Creation was no problem an I can login under that account > from SQL Studio. > > The problem is, that the user dont seems to have an own name > space. When > I create a table, it shows up under the node of the dba user.
Have you authenticated as this user? I just assume that you have remained in the SQL session of the DBA after creating the user ... So, after doing e.g. CREATE USER TEST IDENTIFIED BY TEST DBA in SQL Studio, you must log in as that user, to create any object belonging to him. > > Please, can someone tell me how to create a user with own > name space for > own tables, squences and procedures and the right to create them?! > > By the way, the next step would be backup. I played around a > little with > the backup facilities of sabdb. I managed to create auto log > backups and > complete data backups. But in my case I have to do different > backups for > every user that represents a database. A backup means to store the state of the database present at a certain point of time safely, to have at hand it when something unexpected happens. This is done in different strategies but always some backup command applies to a database as whole. I assume you want to have the possibility to extract only the data of one user, to take it with you and put it into another database. Such logical extraction, also known as replication, can be done using the loader / replication manager tool supplied with SAP DB. Just see http://www.sapdb.org/7.4/htmhelp/2d/c6c63522b8057ce10000009b38f889/frameset.htm for its documentation. Regards Alexander Schr�der SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
