|
|
|
Jonathan Moules created |
|
Issue Type: |
|
|
Assignee: |
|
|
Created: |
19/Dec/12 4:29 AM |
|
Description: |
(Asked on the mailing list, but no-one replied, so reporting it here. Unsure whether it should be considered a bug or “enhancement”.) I’ve created an Oracle store using Oracle NG. This works, however when I go to layers and use this store, it lists 2098 items. There are only 928 tables that the user has access to. It seems to have included all manner of system tables, such as “ALL_COL_PRIVS” etc. I can’t conceive of why anyone would want to publish those sorts of things via GeoServer, so shouldn’t it just list the actual tables that user has access to? http://stackoverflow.com/questions/205736/oracle-get-list-of-all-tables - advises how to get all tables. I’d suggest using a slightly amended version of the second one: select TABLE_NAME from all_tables where TABLE_NAME NOT LIKE ‘MDRT_%’ Tables beginning MDRT_ are Oracle spatial indices and can be ignored safely. |
|
Project: |
|
|
Priority: |
|
|
Reporter: |
Major