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