Tim

As part of my migration of my app I'm running the following code

  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"');

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.

Roy Lambert

I've now found


"and there is one pre-defined Administrator user that can be modified or deleted" in the users table definition.

It seems incorrect I can delete it (with nasty effects) and I can (thankfully) alter the password.

Roy Lambert

Roy,

<< As part of my migration of my app I'm running the following code

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"');

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. >>

This is fixed for 1.07 - there's still a stray reference in there to the
Administrator grantor of the Administrators role to TFR.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>This is fixed for 1.07 - there's still a stray reference in there to the
>Administrator grantor of the Administrators role to TFR.

Which is fixed, the reference in the manual saying I can, or the nasty side effect of doing so, or being allowed to?

Roy Lambert

Roy,

<< Which is fixed, the reference in the manual saying I can, or the nasty
side effect of doing so, or being allowed to? >>

The AV is fixed.

--
Tim Young
Elevate Software
www.elevatesoft.com