- Alias user creates a table
- 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
- SAP Adaptive Server Enterprise(ASE) all versions
- SAP Business Suite
"alter table" modify loginame alias , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem
About this pageThis 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.