Icon View Incident Report

Serious Serious
Reported By: Andrew Hill
Reported On: 8/8/2008
For: Version 2.01 Build 4
# 2747 GRANT ALL PRIVILEGES Statement Not Working Properly

My code below does not grant any privileges.

// Grant Role To Database
if Query.Active then Query.Close;
Query.SQL.Clear;
Query.SQL.Add('GRANT ALL PRIVILEGES ON "SYMTELDB" TO "Client" ;');
try
  Query.ExecSQL;
except
end;



Comments Comments and Workarounds
The workaround is to grant each privilege individually instead.


Resolution Resolution
Fixed Problem on 8/9/2008 in version 2.01 build 5


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image