SAP Knowledge Base Article - Preview

3715902 - Error when attempting to add login with name containing an apostrophe - SAP ASE

Symptom

Using "create login" command or executing sp_addlogin procedure:


1> set quoted_identifier on
2> go

1> create login O'name with passoword "password"
2> go
Msg 105, Level 15, State 2:
Server 'ase16sp04pl04', Line 1:
Unclosed quote before the character string 'name with passoword "password"
'.
Msg 102, Level 15, State 181:
Server 'ase16sp04pl04', Line 1:
Incorrect syntax near 'name with passoword "password"
'.
1> 
2> 
3> create login "O'name" with password "password"
4> go
Msg 203, Level 16, State 3:
Server 'ase16sp04pl04', Line 3:
The name 'O'name' is not a valid identifier.
1> 


Read more...

Environment

SAP Adaptive Server Enterprise

Product

SAP Adaptive Server Enterprise 16.0

Keywords

Error, Msg, 102,  203, create login, sp_addlogin, quoted identifier, syntax error, apostrophe, ', Incorrect syntax, valid identifier, name , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.