| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: privileges oddity |
| Date: | 2020-08-07 17:31:52 |
| Message-ID: | B59F3687-372E-49EE-A200-938E3699A074@elevated-dev.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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???
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2020-08-07 17:39:10 | Re: privileges oddity |
| Previous Message | Adrian Klaver | 2020-08-07 17:14:29 | Re: privileges oddity |