Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Custom password & migration |
Fri, Mar 26 2010 1:38 AM | Permanent Link |
Peter | 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 |
Fri, Mar 26 2010 2:54 AM | Permanent Link |
Peter | Problem solved
Regards Peter |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |