Re: Is there an SQL statement that can change the password of an existing user?

#1

"N. Shamsundar" <shamsundar (AT) uh (DOT) edu> wrote

Quote:

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Is there an SQL statement that can change the password of an existing user?

comp.databases.ibm-db2 comp.databases.ibm-db2

Re: Is there an SQL statement that can change the password of an existing user? - 08-27-2003 , 12:57 PM