This step transfers ownership of the sample database from the default Risk Analytics owner, RAP_USER, to the Sybase IQ user who owns the target database. Before you can transfer ownership, however, you must add the name of this IQ user to the list of users in PowerDesigner.
With the model open in PowerDesigner, select Model | Users and Roles | Users.
In the List of Users dialog, click on the row with the default user name RAP_USER and type the new Sybase IQ user in the Name Column, for example, DBA. PowerDesigner also adds the new user name in the Code column.
Overwriting the default user name globally changes ownership of database objects from the default owner to the new owner.
Click Apply to assign the new user ID to all tables.
Click OK to return to the PowerDesigner desktop.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
