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. 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. Is there a simple way? If not, what is the hard way? Thanks in advance for answering my beginner questions. Mit freundlichen Gr�ssen Alexander Schulz -------------------------------------------------------------------- solutionary GmbH, Reuchlinstrasse 10-11, 10553 Berlin, http://www.solutionary.de mail: [EMAIL PROTECTED] tel 030.343462.40 / fax 030.343462.58 -------------------------------------------------------------------- _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
