From: Mario Splivalo <mario.splivalo@megafon.hr>
To: pgsql-admin@postgresql.org
Subject: Replicating privileges from one user to another
Date: Tue, 19 Jul 2011 21:02:35 +0200
Message-ID: <4E25D4CB.209@megafon.hr> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: mario.splivalo@megafon.hr
Subject: Re: Replicating privileges from one user to another
In-Reply-To: <4E25D4CB.209@megafon.hr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox