To change database owner name

In cases where additional security measures or rapid ownership changes are required, the database administrator can change the database owner name.

  1. On the Tools menu, select Change Owner.

    ChangeOwner.jpg
     

  2. The Select new CONNX table owner dialog box appears.

    ChangeOwner1.jpg
     

  3. Select a new owner from the User list box, and then click the OK button. The database owner changes to the selected user.