Tim,

Currently, to change a user's description we must indicate his password.
Unless there is some drawback, could you make the password optional in
the ALTER USER statement?
--
Fernando Dias
[Team Elevate]

Fernando,

<< Currently, to change a user's description we must indicate his password.
Unless there is some drawback, could you make the password optional in the
ALTER USER statement? >>

This goes back to what we (I believe it was you, my apologies if not
discussed previously regarding ALTER statements requiring a complete
redefinition vs. selective redefinition.  The problem is that you start to
run into the requirement of all kinds of new inverse clauses in the ALTER
statements in order to allow for specifying whether information is present
or not.

However, in the case of the ALTER USER, I see no harm in allowing it to be
left off in this case.  We know that it is required, so if it isn't
specified, then we can safely assume that it should stay the same.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

> This goes back to what we (I believe it was you, my apologies if not
> discussed previously (...)
Yes, it was me.

> However, in the case of the ALTER USER, I see no harm in allowing it to be
> left off in this case.

Great. Thank you, but please don't waste your time with this now - we
are waiting for EDB2
--
Fernando Dias
[Team Elevate]