Symptom
- Attempt to change ownership using the "loginame only" syntax under the sa login yields the following error:
alter table user1_table modify owner loginame only user2
Msg 13998, Level 16, State 1: Server 'sp02', Line 1: Ownership change failed. With LOGINAME ONLY specified, the new owner must have the same user identity in the database as the current owner. - Attempt to change ownership using the "loginame only" syntax under the user2(see Repro below) login yields the following error:
Msg 10370, Level 14, State 1:
Server 'sp02', Line 1:
Permission denied. Only the DBO of the current database or a user with sso_role
Read more...
Environment
SAP Adaptive Server Enterprise(ASE) all version
Product
SAP Adaptive Server Enterprise 16.0
Keywords
"alter table" modify loginame alias , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem
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.
SAP Knowledge Base Article - Preview