Revision 26 branches/org.gvsig.mssqlserver-1.0.1-SP/org.gvsig.mssqlserver.provider/src/main/java/org/gvsig/mssqlserver/dal/operations/MSSQLServerCanModifyTableOperation.java

View differences:

MSSQLServerCanModifyTableOperation.java
41 41 
        SQLBuilder.TableNameBuilder tableNameBuilder = builder.createTableNameBuilder();
42 42 
        String sql = "SELECT count(*) " +
43 43 
                     "FROM fn_my_permissions("+
44 
                     tableNameBuilder.database(dbName).schema(schemaName).name(tableName).toString() +
44 
                     "'"+dbName+"."+schemaName+'.'+tableName+"'" +
45 45 
                     ", 'OBJECT') " +
46 46 
                     "WHERE permission_name in ('UPDATE', 'INSERT', 'DELETE') AND subentity_name = ''";
47 47 
        Statement st = null;

Also available in: Unified diff