Assigning an Owner to an Object

The database user who creates an object (table, view, stored procedure, etc) is the owner of the object and is automatically granted all permissions on it. In a PDM, you can specify the owner of an object by attaching a user to it. Each object can have only one owner. Where other users must access the object, you can restrict object modifications to the owner and grant Select or other permissions for the other users.

Note: To automatically assign a default owner for any type of object that supports the concept of ownership, select Tools > Model Options, choose the appropriate object type in the left-hand pane, and select the appropriate user in the Default owner field (see Other Object Model Options).
  1. Open the property sheet of the object to the General tab.
  2. Select a user in the Owner field. To create a new user, click the Create tool to the right of this field.
  3. Click OK to return to your model.
    Note: When generating to your database (see Generating a Database from a PDM), you can restrict the tables and other objects generated to only those belonging to a particular owner, by selecting the owner on the Database Generation dialog Selection tab.
Parent topic: Users, Groups, and Roles (PDM)