2136018 - sp_drop alias reports Error 17231 "No login ... exists". Unable to drop alias when no login record exists -- SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2136018 - sp_drop alias reports Error 17231 "No login ... exists". Unable to drop alias when no login record exists -- SAP ASE

Symptom

  • Unable to drop alias when no login record exists
  • A check of the sysalternates table and user names shows that some orphaned aliases exist in the database:

    1> select suser_name(suid), * from sysalternates
    2> go
                                    suid        altsuid
     ------------------------------ ----------- -----------
     myuser                                   7           1
     NULL                                   366          1

  • Attempt to remove the orphaned alias fails:

    1> sp_dropalias NULL
    2> go

    Msg 17231
    , Level 16, State 1:
    Server 'SYBASE', Procedure 'sp_dropalias', Line 176:
    No login with the specified name exists.

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

KBA , syslogins , orphaned , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.