SAP Knowledge Base Article - Preview

2453995 - Got error 19876 when running sp_droplogin / drop login - SAP ASE

Symptom

User would like to drop a login while the login is owner of database "dbccdb".  They had already run sp_changedbowner to change database owner to the new owner.  Got error 13978 when running "alter procedure" on dbcc SPs to change ownership of dbcc SPs to 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 ONE Support launchpad (Login required).

Search for additional results

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