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
1> alter procedure dbo.sp_dbcc_alterws modify owner user1
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
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this pageThis 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.