SAP Knowledge Base Article - Preview

2453995 - Error 19876 when running sp_droplogin / drop login - SAP ASE

Symptom

User would like to drop a login that is the owner of database "dbccdb".

They had already run sp_changedbowner to change database owner to a new owner, but error 19876 was raised when they tried to drop the login.

Msg 19876, Level 0, State 1
User 'xxxx' concretely owns object(s) in at least one database. Alter the object ownership before dropping the login.

Error 13978 was then raised when running "alter procedure" on dbcc stored procedures to change ownership ofthe procedures to the new owner.

1> use dbccdb
2> go
1> alter procedure dbo.sp_dbcc_alterws modify owner user1
2> go
Msg 13978, Level 11, State 3:
Server 'XXXX', Line 1:
Ownership change failed. User 'dbo' does not own procedure 'sp_dbcc_alterws'.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 and higher
SAP Adaptive Server Enterprise (ASE) 16.0 and higher

Product

SAP Adaptive Server Enterprise 15.7

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.