RAP repository  Generating a DDL script

Chapter 4: Generating DDL Scripts

Changing the default database user

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. Risk Analytics data models ship with a default database owner named RAP_USER.

You may want to overwrite the default database owner with a name specific to your environment. Overwriting the default user name globally changes ownership of database objects from the default owner to the new owner.

  1. Start PowerDesigner 11.1.

  2. Click File | Open | Choose RAP_IQ.pdm.

  3. Click Model | Users and Roles | Users.

  4. In the Name column, change the default user (RAP_USER) to the new database user you want to use.

  5. Click Apply.





Copyright © 2005. Sybase Inc. All rights reserved. Generating a DDL script

View this book as PDF