I would like to create a user limited to only one spatial table. I gave all permissions to the spatial table + MDSYS SDO_GEOM_METADATA_TABLE tables. But I still can not use that user for drawing the table data. Anybody knows if I need to give permission to any other tables to fix this issue?
What query does not work for you? Do you have any spatial indexes?