Re: view to get all role privileges

Поиск
Список
Период
Сортировка
От Huang, Suya
Тема Re: view to get all role privileges
Дата
Msg-id D83E55F5F4D99B4A9B4C4E259E6227CDA035A1@AUX1EXC02.apac.experian.local
обсуждение исходный текст
Ответ на Re: view to get all role privileges  (Raghu Ram <raghuchennuru@gmail.com>)
Ответы Re: view to get all role privileges  (Raghu Ram <raghuchennuru@gmail.com>)
Список pgsql-novice
Дерево обсуждения

Hello Ram,

 

The create schema privilege is missed from the dump file.

 

Thanks,

Suya

 

From: Raghu Ram [mailto:raghuchennuru@gmail.com]
Sent: Thursday, November 07, 2013 4:06 PM
To: Huang, Suya
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] view to get all role privileges

 

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 по дате отправления:

Предыдущее
От: Raghu Ram
Дата:
Сообщение: Re: view to get all role privileges
Следующее
От: "Huang, Suya"
Дата:
Сообщение: Re: view to get all role privileges