Symptom
We tried to create an user with NULL password but these syntax didn't work:
=====
1> create user user01 identified by "NULL"
2> go
Msg 573, Level 14, State 0:
SQL Anywhere Error -738: Password must be at least 6 characters
1> create user user01 identified by 'NULL'
2> go
Msg 573, Level 14, State 0:
SQL Anywhere Error -738: Password must be at least 6 characters
1> create user user01 identified by 'null'
2> go
Msg 573, Level 14, State 0:
SQL Anywhere Error -738: Password must be at least 6 characters
=====
This syntax worked:
======
1> create user user01 identified by NULL
2> go
=====
But we can not connect:
=====
[i824931@ccus1gl0447 demo]$ isql -Uuser01 -P -Siqdemo2
Msg 4002, Level 14, State 0:
SQL Anywhere Error -103: Invalid user ID or password
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
[i824931@ccus1gl0447 demo]$ isql -Uuser01 -PNULL -Siqdemo2
Msg 4002, Level 14, State 0:
SQL Anywhere Error -103: Invalid user ID or password
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
i824931@ccus1gl0447 demo]$ isql -Uuser01 -P"NULL" -Siqdemo2
Msg 4002, Level 14, State 0:
SQL Anywhere Error -103: Invalid user ID or password
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.
=====
Read more...
Environment
SAP IQ 16.1
Keywords
create alter user identified by password null NULL value empty min_password_length 573 Password must be at least characters , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.