Ticket #1813 (closed defect: fixed)
geometry_columns / geography_column table fails to take into account user permissions to table
|Reported by:||chander||Owned by:||pramsey|
The current geometry_columns table often lists tables that might not exist for a user (or might not be visible to them) because it fails to take into account the users current search path.
I believe the SQL code for the view should have the following appended to it:
This would result in spatial_ref_sys only displaying information for tables that exist in the current search_path.