Changing Database Ownership

Use the Database Properties wizard to change the owner of a database.

You can change ownership of a database to a user who is not a current user of the database and who does not have a current alias in the database.

Note: Only system administrators can change database ownership.
  1. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Databases.
  2. Select one of:
    • User Databases
    • System Databases
    • Temporary Databases
    • Proxy Databases
    • Archive Databases
    • In-Memory Databases
    • In-Memory Temporary Databases
  3. Click the Name field of the database.
  4. Click the arrow and select Properties.
    Sybase Control Center displays the Properties wizard.
  5. On the default General screen, click Change Owner.
  6. From the list, choose the login name for the new owner of the database. Additionally, you can choose to transfer all the aliases and their permissions to the new owner.
  7. Click OK.
Related tasks
Modifying Database Storage Allocations
Modifying the Transaction Log Cache and the Log I/O Buffer Size
Changing Database Options
Viewing Database Statistics
Related reference
Database Properties