#949 closed task (fixed)
Check if joining to pg_authid is necessary for listing materialized views
Reported by: | jng | Owned by: | jng |
---|---|---|---|
Priority: | major | Milestone: | 4.1.0 |
Component: | PostgreSQL Provider | Version: | 4.1.0 |
Severity: | 3 | Keywords: | |
Cc: | External ID: |
Description
#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.
Note:
See TracTickets
for help on using tickets.
In 7953: