Re: How to control pg_catalog results for each users?

2023-01-29 Thread Tom Lane
"David G. Johnston" writes: > On Sunday, January 29, 2023, hirose shigeo(廣瀬 繁雄 □SWC○ACT) < > shigeo.hir...@toshiba.co.jp> wrote: >> Has there been any discussion or development on controlling this system >> catalog information on a per-user > I found this one: > https://www.postgresql.org/message

Re: How to control pg_catalog results for each users?

2023-01-29 Thread David G. Johnston
On Sunday, January 29, 2023, hirose shigeo(廣瀬 繁雄 □SWC○ACT) < shigeo.hir...@toshiba.co.jp> wrote: > > Has there been any discussion or development on controlling this system > catalog information on a per-user > I found this one: https://www.postgresql.org/message-id/flat/20160107032927.GT3685%

How to control pg_catalog results for each users?

2023-01-29 Thread 廣瀬 繁雄 □SWC○ACT
Hello, PostgreSQL provides pg_catalog as a system catalog. However, PostgreSQL does not allow different users to retrieve different table structures or table names using pg_catalog. For example, when SELECT * FROM pg_catalog.pg_tables is executed by User1 and User2, it is not possible to get di