Changing the Default Database User

You may want to overwrite the default database owner 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. Sybase RAP data models ship with a default database owner named RAP_USER.

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 | RAPCache.pdm.
  3. Select Model | Users and Roles | Users.
  4. In the Name and Code columns, change the default user (RAP_USER) to the new database user.
  5. Click OK.
Parent topic: Generating DDL Scripts for the RAPCache Database

Created March 26, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com