PostgreSQL SQL Grants

[HariSekhon]

The latest docs for 0.188 say that the PostgreSQL connector doesn't support SQL Grants.

Given that the catalog definition for only has a single "connection-user" the PostresSQL native grants would not be able to differentiate between Presto users connecting through to PostgreSQL so it looks like it would be all or nothing access right now, which means there is currently no authorization for PostgreSQL in Presto and will be DoA in security conscious environments.

Any chance of adding SQL Grants support for PostgreSQL connector?

I'm looking here:

https://prestodb.io/docs/current/connector/postgresql.html

[HariSekhon]

Also relates to getting Ranger integration #8980

[findepi]

Related: #11475. This is roles/grants support for Hive connector. Postgres connector can build on that.

[stale]

This issue has been automatically marked as stale because it has not had any activity in the last 2 years. If you feel that this issue is important, just comment and the stale tag will be removed; otherwise it will be closed in 7 days. This is an attempt to ensure that our open issues remain valuable and relevant so that we can keep track of what needs to be done and prioritize the right things.