Hi all, I would like to create a database based upon a template which also contains some tables. After invoking
psql -T <templateName> -U <dbuser> -O <dbowner> test the new database 'test' belongs to <dbowner> but all tables are still belonging to the user who owns the template <templateName>. This results in the following error message when accessing the tables: ERROR: permission denied for relation <some table> Of course, I could alter the permissions in way that <dbowner> has access to all tables. But it would be much nicer, if the owner of the cloned database were inherited to all tables. Is there a way to achieve this? Thanks in advance, Stefan. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly