privileges oddity
От
Scott Ribe
Тема
privileges oddity
Дата
Msg-id
C2C6B9DD-6EFD-49DA-8673-1BBDA260329D@elevated-dev.com
Список
Дерево обсуждения
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>
when user akanzler tries to run query "SELECT * FROM zoewang.sometable...", it triggers this error:
2020-08-06 17:27:27.664 UTC [15914]: [3] user=akanzler,db=risk_oltp_prod,app=[unknown],client=10.8.170.24: ERROR: permission denied for schema zoewang at character 15
--- YET ---
risk_oltp_prod=# \dn+ zoewang
List of schemas
Name | Owner | Access privileges | Description
---------+----------+------------------------+-------------
zoewang | srv_risk | srv_risk=UC/srv_risk +|
| | akanzler=UC/srv_risk +|
| | srv_risk_ro=U/srv_risk |
(1 row)
HUH? (And the user also has all privs on all the tables in the schema...)
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
В списке pgsql-general по дате отправления
От: David Gauthier
Дата: