SAP Knowledge Base Article - Preview

3241204 - Error 13998 or 10370 maybe seen when Alter table modify owner loginame is changed for aliased users

Symptom

  1. Alias user creates a table
  2. 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.

  3. 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 versions
  • SAP Business Suite 

Keywords

"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 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.