Re: privileges oddity
| От | Scott Ribe |
|---|---|
| Тема | Re: privileges oddity |
| Дата | |
| Msg-id | B59F3687-372E-49EE-A200-938E3699A074@elevated-dev.com обсуждение исходный текст |
| Ответ на | Re: privileges oddity (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Ответы |
Re: privileges oddity
|
| Список | pgsql-general |
>
> 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 по дате отправления: