Transfer of Database Object Ownership

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

To support 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 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 15.7.1 SP100 adds support for transferring object ownership in replication definitions. 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. To ensure that data replicates continuously and correctly, coordinate any changes to object ownership with corresponding changes to affected replication definitions.

See Transfer of Database Object Ownership in the Replication Server Administration Guide Volume 1.