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.