Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
Administrator's LoginPassword |
Fri, Jun 8 2007 9:47 PM | Permanent Link |
Alfred Ghazzi | Hi
I want to be able to change the Default Administrator LoginPassword (EDBDefault) to something else. I tried to drop the user and create a new one called Administrator with the new password. When I try to drop the user from the EDBManager, I get ElevateDBError #300 Cannot lock user administrator for exclusive access Is there some other way? Please advise me and many thanks Alfred |
Mon, Jun 11 2007 1:48 PM | Permanent Link |
Michael Thompson | I think you have to create the new user first, then login with that user and then delete.
Alfred Ghazzi <alfred@maxiworks.com> wrote: Hi I want to be able to change the Default Administrator LoginPassword (EDBDefault) to something else. I tried to drop the user and create a new one called Administrator with the new password. When I try to drop the user from the EDBManager, I get ElevateDBError #300 Cannot lock user administrator for exclusive access Is there some other way? Please advise me and many thanks Alfred |
Mon, Jun 11 2007 3:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Alfred,
<< I want to be able to change the Default Administrator LoginPassword (EDBDefault) to something else. I tried to drop the user and create a new one called Administrator with the new password. When I try to drop the user from the EDBManager, I get ElevateDBError #300 Cannot lock user administrator for exclusive access >> Michael is correct - you need to either add the new Administrator user with the new password first, and then drop it using that user, or you can just use the ALTER USER statement: http://www.elevatesoft.com/edb1sql_alter_user.htm to change the password, which might be a little easier. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Jun 12 2007 3:02 AM | Permanent Link |
Alfred Ghazzi | Michael and Tim
Thank you very much for your kind help Alfred |
This web page was last updated on Tuesday, May 7, 2024 at 02:40 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |