2470874 - unable to drop logins that were aliased to dbo in a database and created objects - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2470874 - unable to drop logins that were aliased to dbo in a database and created objects - SAP ASE

Symptom

There are a couple of errors encountered when items were created by a login aliased to dbo; then the login needs to be dropped.

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 'pubs2'  database(s).
(1 row affected)
(return status = 1)

use pubs2
go

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.
(1 row affected)
name                               type
---------------------------------
abc                                  U
a12                                  U
(2 rows affected)
(return status = 1)

1> sp_help abc
2> go
1> sp_help abc
2> go
 Name     Owner         Object_type         Object_status        Create_date
 -------- ------------ - ----------------      ------------------     --------------------------
 abc         dbo            user table          -- none --                May  2 2017  8:41PM
.
.
.


Read more...

Environment

SAP Adaptive Server Enterprise ASE

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

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