Re: [GENERAL] Get the list of permissions/privileges on schema

Поиск
Список
Период
Сортировка
От dipti shah
Тема Re: [GENERAL] Get the list of permissions/privileges on schema
Дата
Msg-id d5b05a951003300240l3780b1c8s7dee8acf055523e6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Get the list of permissions/privileges on schema  (Ashesh Vashi <ashesh.vashi@enterprisedb.com>)
Список pgsql-novice
Дерево обсуждения
Thanks Ashesh, I ran below command and it is listing all privileges of objects under mydb schema. Actually, I want to know what are the permissions "user1" has on mydb schema. Could you please tell me how to do this?

mydb=# select pc.relname, pc.relacl from pg_class pc, pg_namespace pn where pc.relnamespace=pn.oid and pn.nspname='mydb';
             relname              |                    relacl
----------------------------------+-----------------------------------------------
  mylog                           | {postgres=arwdDxt/postgres,=arwdDxt/postgres}
  techtable                       | {postgres=arwdDxt/postgres,=ar/postgres}
  techtable_log                   |
  hrtable                         | {postgres=arwdDxt/postgres,=ar/postgres}
  hrtable_log                     |
(5 rows)


mydb=> select current_user;
 current_user
--------------
 user1
(1 row)

mydb=>

Thanks,
Dipti

On Thu, Mar 25, 2010 at 2:44 PM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
You should look into the pg_class table : relacl attribute for the permissions on any object.

--
Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company


On Thu, Mar 25, 2010 at 2:37 PM, dipti shah <shahdipti1980@gmail.com> wrote:
Hi,
 
Could any one please tell me how to get list of all the permissions on the schema (or any postgresql objects), stored them somewhere before executing stored procedure and then restore them?
 
Thanks,
Dipti


В списке pgsql-novice по дате отправления:

Предыдущее
От: Jasen Betts
Дата:
Сообщение: What happens if the partitions overlap?
Следующее
От: Thom Brown
Дата:
Сообщение: Re: What happens if the partitions overlap?