SAP Knowledge Base Article - Preview

3431275 - Create a user with NULL password - SAP IQ

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.