[Geoserver-devel] [jira] Created: (GEOS-4134) When use SQL Layer it possible to execute "delete from myTable" query

When use SQL Layer it possible to execute "delete from myTable" query
---------------------------------------------------------------------

                 Key: GEOS-4134
                 URL: http://jira.codehaus.org/browse/GEOS-4134
             Project: GeoServer
          Issue Type: Bug
          Components: Configuration
    Affects Versions: 2.1-beta1
         Environment: Geoserver 2.1-beta1
jdk 1.6-u20
windows server 2003
            Reporter: Lazarev Eugene
            Assignee: Justin Deoliveira

this feature has very big leak. if we enter "delete from myTable" in query window, it will be delete all table data. i think the better way is always use views and tables. this method will ensure security and protect data.
another problem that is this feature isn't geoserver abstraction architecture level, this should be in database level.

so i think we must move this function to additional plugin group not in release, and of cause fix this problem with non-select queries.

--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira