Changing the Default Database User

Overwrite the default database owner for the SAP Sybase IQ, SAP HANA, or ASE database with a name specific to your environment.

In the database, the user who creates an object (table, view, stored procedure, and so on) owns that object and is automatically granted all permissions on it. Overwriting the default user name globally changes ownership of database objects from the default owner to the new owner.

  1. Start PowerDesigner.
  2. Select File > Open and choose the database that you want to change the default owner of ( IQ.pdm, HANA.pdm, or ASE.pdm).
  3. Select Model > Users and Roles > Users.
  4. In the Name and Code columns, change the default user to the new database user.
  5. Click OK.
Parent topic: Generating Database Schema with PowerDesigner