Postgres Pro
Downloads
Home   >   mailing lists

Re: view to get all role privileges - Mailing list pgsql-novice

From Raghu Ram
Subject Re: view to get all role privileges
Date
Msg-id CALnrrJTkkFY=qJsX52f8kU7PwLPoAL4WGOzyBCidSgc6Fa7Yxw@mail.gmail.com
Whole thread Raw
In response to Re: view to get all role privileges  ("Huang, Suya" <Suya.Huang@au.experian.com>)
Responses Re: view to get all role privileges
List pgsql-novice
Tree view

On Thu, Nov 7, 2013 at 10:25 AM, Huang, Suya <Suya.Huang@au.experian.com> wrote:

Thanks Ram, but those command doesn’t help here… The goal is to dump all privileges in a database and execute it on the new database to make sure we have exactly the same environment.

 


Command to get all privileges from respective Database:

 /opt/PostgreSQL/9.2/bin/pg_dump -s -U postgres -c  ksnp |egrep "${SCHEMAS}\..*OWNER TO" >> /tmp/privilagesddl.sql

Here,ksnp is a database name and then execute  "/tmp/privilagesddl.sql" file to newly created database.

Thanks & Regards
Raghu Ram

pgsql-novice by date:

Previous
From: Jayadevan M
Date:
Subject: Re: view to get all role privileges
Next
From: "Huang, Suya"
Date:
Subject: Re: view to get all role privileges