Reported By: Andrew Hill Reported On: 8/8/2008 For: Version 2.01 Build 4
# 2747GRANT 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 and WorkaroundsThe workaround is to grant each privilege individually instead.
ResolutionFixed Problem on 8/9/2008 in version 2.01 build 5
Products AffectedElevateDB 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