I have user foo that is owner of database dbfoo. Now I need to create user baz that will have the exact same privileges as user foo on database baz. I've tried this:

GRANT ALL ON DATABASE dbfoo TO baz;

but I still can't select form tables.

Is there a easier way, or do I need to go trough all the tables/views/functions/schemas and issue GRANT ALL ON ... TO USER baz?

        Mario

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply via email to