Re: view to get all role privileges

From: Raghu Ram <raghuchennuru(at)gmail(dot)com>
To: "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: view to get all role privileges
Date: 2013-11-07 05:05:46
Message-ID: CALnrrJTkkFY=qJsX52f8kU7PwLPoAL4WGOzyBCidSgc6Fa7Yxw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Thu, Nov 7, 2013 at 10:25 AM, Huang, Suya <Suya(dot)Huang(at)au(dot)experian(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Huang, Suya 2013-11-07 05:10:07 Re: view to get all role privileges
Previous Message Jayadevan M 2013-11-07 04:59:21 Re: view to get all role privileges