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

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

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

Michael and Tim

Thank you very much for your kind help

Alfred