Re: privileges oddity

Поиск
Список
Период
Сортировка
Искать
От
Scott Ribe
Тема
Re: privileges oddity
Дата
Msg-id
B59F3687-372E-49EE-A200-938E3699A074@elevated-dev.com
Ответ на
Re: privileges oddity (Adrian Klaver)
Список
Дерево обсуждения
privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Stephen Frost <sfrost@snowman.net>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Tom Lane <tgl@sss.pgh.pa.us>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Tom Lane <tgl@sss.pgh.pa.us>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Tom Lane <tgl@sss.pgh.pa.us>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Tom Lane <tgl@sss.pgh.pa.us>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Tom Lane <tgl@sss.pgh.pa.us>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
Re: privileges oddity Scott Ribe <scott_ribe@elevated-dev.com>
Re: privileges oddity Adrian Klaver <adrian.klaver@aklaver.com>
> 
> What happens if you do?:
> 
> select has_schema_privilege('akanzler', 'zoewang', 'usage');

risk_oltp_prod=# select has_schema_privilege('akanzler', 'zoewang', 'usage');
has_schema_privilege
----------------------
t
(1 row)

> In psql what does
> 
> \ddp
> 
> show?

risk_oltp_prod=# \ddp
                        Default access privileges
    Owner      |  Schema  | Type  |           Access privileges
----------------+----------+-------+----------------------------------------
...
srv_risk       | zoewang  | table | akanzler=r/srv_risk                   +
               |          |       | srv_risk=arwdD/srv_risk
...
(40 rows)


Wondering if there's a code path somewhere that lets the default take precedence???

В списке pgsql-general по дате отправления
От: Adrian Klaver
Дата:
Сообщение: Re: privileges oddity
От: Scott Ribe
Дата:
Сообщение: Re: privileges oddity
FAQ