3386824 - How to change owner of a database object? - SAP ASE

• How to change the owner of a Stored Procedure from one user to another user?
• Unable to drop an ASE login account due to object ownership error 19587/17545:
      
  sp_droplogin test1
  go
  Msg 19587, Level 16, State 1:
  Server 'XXXX', Procedure 'sp_droplogin', Line 376:
  User exists or is an alias or is a database owner in 'sybsystemprocs'
  database(s).
  
  sp_dropuser test1
  go
  Msg 17545, Level 16, State 1:
  Server 'XXXX', Procedure 'sp_dropuser', Line 300:
  
  You cannot drop user because user 'test1' owns objects in database.
   name           type
   -------------------------------------------------
   sp1               P

SAP Adaptive Server Enterprise

sp_droplogin, drop login, alter table, alter, modify owner, 17545, 19587, Msg 17545, Msg 19587 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem