Postgres Pro
Downloads
Home   >   mailing lists

Replicating privileges from one user to another - Mailing list pgsql-admin

From Mario Splivalo
Subject Replicating privileges from one user to another
Date
Msg-id 4E25D4CB.209@megafon.hr
Whole thread Raw
Responses Re: Replicating privileges from one user to another
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: "Kyle R. Burton"
Date:
Subject: 9.0 Replication and archive cleanup
Next
From: "Kevin Grittner"
Date:
Subject: Re: Replicating privileges from one user to another