Transfer of Database Object Ownership

Replication Server supports the transfer of database object ownership in Adaptive Server.

For employee life cycle management in Adaptive Server, database administrators, system security officers, or database owners can manage the assignment of database objects due to employee changes by transferring the ownership of database objects using the alter... modify owner Adaptive Server command. In addition, database administrators can can separate the creation of objects from the ownership of objects by using alter... modify owner. See Adaptive Server Enterprise Security Administration Guide > Managing User Permissions > Changing database object ownership.

• Replication Server Support for Transferring Object Ownership
  Replication Server replicates the DDL changes generated by alter... modify owner so that the transfers in object ownership at the primary Adaptive Server database are applied to the replicate Adaptive Server database. However, if there is a change in object ownership for an object qualified with an owner, in a replication definition where the owner name is required, Replication Server does not automatically alter the replication definition to reflect the change.