SAP Knowledge Base Article - Preview

3531772 - Error when attempting to add login with name containing a hyphen or period - SAP ASE

Symptom

  • Using CREATE LOGIN command or executing sp_addlogin procedure
  • Error 102 when "quoted identifier" option is off

1> set quoted_identifier off
2> go
1> create login a-b with password "password"
2> go
Msg 102, Level 15, State 181:
Server 'ase_1604', Line 1:
Incorrect syntax near '-'.

  • Error 203 when "quoted identifier" option is on

1> set quoted_identifier on
2> go
1> create login "a-b" with password "password"
2> go
Msg 203, Level 16, State 2:
Server 'ase_1604', Line 1:
The name '"a-b"' is not a valid identifier.


Read more...

Environment

SAP Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise all versions

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.