SAP Knowledge Base Article - Preview

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


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'.



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


SAP Adaptive Server Enterprise 15.7


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.