From: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com> |
---|---|
To: | Raghu Ram <raghuchennuru(at)gmail(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:10:07 |
Message-ID: | D83E55F5F4D99B4A9B4C4E259E6227CDA035A1@AUX1EXC02.apac.experian.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello Ram,
The create schema privilege is missed from the dump file.
Thanks,
Suya
From: Raghu Ram [mailto:raghuchennuru(at)gmail(dot)com]
Sent: Thursday, November 07, 2013 4:06 PM
To: Huang, Suya
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] view to get all role privileges
On Thu, Nov 7, 2013 at 10:25 AM, Huang, Suya <Suya(dot)Huang(at)au(dot)experian(dot)com<mailto: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
From | Date | Subject | |
---|---|---|---|
Next Message | Huang, Suya | 2013-11-07 05:11:56 | Re: view to get all role privileges |
Previous Message | Raghu Ram | 2013-11-07 05:05:46 | Re: view to get all role privileges |