Hello

I have developed my own migration facility, and all went swimmingly until I decided to use a custom password for the Administrator. As part of the migration I set the password and a new user with lesser privileges

SCRIPT
BEGIN
DECLARE TempCursor CURSOR FOR stmt;
PREPARE stmt FROM 'SELECT * FROM Configuration.Users WHERE Name = ?';
OPEN TempCursor USING 'User1';
IF (ROWCOUNT(TempCursor) > 0) THEN
 EXECUTE IMMEDIATE 'DROP USER "User1"';
END IF;
CLOSE TempCursor;
EXECUTE IMMEDIATE 'CREATE USER "User1" PASSWORD ''xxxx'' ';
PREPARE stmt FROM 'SELECT * FROM Configuration.Roles WHERE Name = ?';
OPEN TempCursor USING 'NonAdministrator';
IF (ROWCOUNT(TempCursor) < 1) THEN
 EXECUTE IMMEDIATE 'CREATE ROLE "NonAdministrator"';
END IF;
EXECUTE IMMEDIATE 'GRANT "NonAdministrator" TO "User1"';
EXECUTE IMMEDIATE 'REVOKE SELECT, DELETE, ALTER ON TABLE "SecretTbl" FROM Public';
EXECUTE IMMEDIATE 'REVOKE SELECT, DELETE, ALTER ON TABLE "PsNotes" FROM Public';
EXECUTE IMMEDIATE 'ALTER USER "Administrator" PASSWORD ''yyyy'' ';
END

The problem is that the migrator opens up the EDB Remote login dialog if they have done a migration previously. A trial conversion is a great idea, soI need to know how to treat the password issue.

I suspect that the password is somewhere other than in the config files, as I also tried deleting all of them, and still get the Remote login dialog.

Could you suggest how I should approach this issue?

Regards

Peter

Problem solved

Regards

Peter