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.
Change History (8)
comment:2 by , 12 years ago
|Summary:||geometry_columns table fails to take into account the current schema search_path → geometry_columns / geography_column table fails to take into account user permissions to table|