Changing Database Ownership

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

System administrators can change the 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.

  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, then click the drop-down arrow and select Properties.
  4. On the default General screen, click Change Owner.
  5. From the list, choose the login name for the new owner of the database. Additionally, you can choose to transfer all aliases and their permissions to the new owner.
  6. 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