Opened 5 years ago
Closed 3 years ago
Last modified 3 years ago
#949 closed task (fixed)
Check if joining to pg_authid is necessary for listing materialized views
|Reported by:||jng||Owned by:||jng|
#943 added support for materialized views. However the SQL to query for these materialized views includes a join to the
pg_authid table/view which seems unnecessary as the joined table is not part of any output columns or where clauses.
For the purpose of attack surface reduction, we should check if this join is even necessary and remove it if such a join is not necessary.
Change History (3)
comment:1 by , 3 years ago
|Status:||assigned → closed|
comment:2 by , 3 years ago
comment:3 by , 3 years ago
Note: See TracTickets for help on using tickets.