Assigning an Owner to an Object

In a database, the user who creates an object (tables, views, stored procedures, etc) is the owner of the object and is automatically granted all permissions on it.

When building a PDM, you must attach the user to the object in order to make it the owner. Each object can have only one owner. In a model where many users have access to the same objects, you can restrict object modifications to the owner and define permissions for the other users.

Owners can also be used during generation: when you select to generate for a selected owner, only the tables belonging to this owner are generated, whereas when you generate as ADMIN, you generate all the tables on behalf of all their owners.

Open the property sheet of the object.
Select a user in the Owner list. You can create a new user by clicking the ellipsis button to the right of the Owner list.
Click OK.

Specifying Default Owners for Object Types
You can specify a default owner for each type of object that supports the concept of ownership. The default owner will automatically be linked to all the objects of this type that you create after making this change.

Parent topic: Users, Groups, and Roles (PDM)