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.
SAP Knowledge Base Article - Preview