SAP Knowledge Base Article - Preview

2470874 - Unable to drop login with alias - SAP ASE

Symptom

  • Unable to drop login with alias to dbo in a database and owning objects
  • Error(s) raised when trying to drop login that still owns object via alias:
    sp_droplogin mylogin
    go
    Msg 19587, Level 16, State 1:
    Server 'ASE', Procedure 'sp_droplogin', Line 376:

    User exists or is an alias or is a database owner in 'db_name' database(s).

    drop login mylogin
    go
    The login 'mylogin' is still a user, alias or database owner in 'db_name' database.
    Msg 3770, Level 16, State 1:
    The DROP login 'mylogin' failed. See previous messages for more information.

    sp_dropalias mylogin
    go

    Msg 18790, Level 16, State 1:
    Server 'ASE', Procedure 'sp_dropalias', Line 204:

    You cannot drop the alias for login 'mylogin' because 'mylogin' owns objects in the database.
    (followed by listing of objects owned)
    name                               type
    -------------------------------   -----
    abc                                  U


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

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.