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.