Icon View Incident Report

Serious Serious
Reported By: Roy Jones
Reported On: 7/14/2004
For: Version 4.08 Build 1
# 1784 SQL DROP TABLE or CREATE TABLE Statements Not Respecting User Rights Properly

I am trying to execute code similar to the following but am getting error 11288. If I select the necessary values for the "Rights to Grant" using the Server Admin Utility and try to execute code similar to the following the above error occurs (Both in the Application
and DBSYS). However, if I give the user admin rights the code works fine.

drop table if exists "RAddress.DAT";
create table if not exists "RAddress.DAT" 
       (MID Integer,
       MTDescription char(30),
       MTID Integer,
       TID Integer,
       MSurname Char(30),
       APostCode Char(10),
       MParentID Integer,
       TagRenewal Boolean,
       Salutation Char(50),
       Primary Key (MID));
create index if not exists "ixName" on "RAddress" ("MSurname","APostCode");



Resolution Resolution
Fixed Problem on 7/16/2004 in version 4.09 build 1
Image