Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 12/26/2007
For: Version 1.06 Build 1
# 2505 Dropping the System-Defined Administrator Causes AV When Querying Configuration Database

As part of my migration of my app I'm running the following code. When I create a session in EDBManager, setting the login to TFR I get an AV. If I comment out Execute('DROP USER "Administrator"'); its OK.

Execute('CREATE USER "TFR"  PASSWORD ''tfr''  DESCRIPTION ''TfR Conversion''');
Execute('GRANT "Administrators"  TO "TFR"');
Execute('CREATE USER "TfRLogon"  PASSWORD ''TfR Logon''  DESCRIPTION ''TfR Logon User''');
Connected := False;
LoginUser := 'TFR';
LoginPassword := 'tfr';
Connected := True;
Execute('DROP USER "Administrator"');



Comments Comments
The problem was caused by a reference in the roles to the now non-existent Administrator user as the grantor of the role.


Resolution Resolution
Fixed Problem on 12/28/2007 in version 1.07 build 1


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