"N. Shamsundar" <shamsundar@uh.edu> wrote in message news:<bidjop$8cf$1@masala.cc.uh.edu>...
> DD2 relies on the OS to authenticate users. What you want to do is
> probably to "GRANT CONNECT ... ", which you should look up in the SQL
> documentation, NOT changing the password.
>
> N. Shamsundar
> University of Houston
>
> FBT wrote:
> > Is there an SQL statement that can change the password of an existing
> > user? My users don't have the access to use the Connect to...
> > statement.
> >
> > Thanks
> > FBT.
How is GRANT CONNECT going to help me change the users password? By
access I mean the users are not running command center. I want to
include a change in my custom app. And if I send the Connect to
statement, I get the error [IBM][CLI Driver] CLI0118E Invalid SQL
syntax. SQLSTATE=37000.