Modifying privileges on data objects in a physical data model

Use the Properties view to modify privileges on data objects, such as tables and views, that are contained in a physical data model.

Before you begin

Before you modify privileges on data objects in physical data models, you must open a physical data model in the physical data model editor.

Procedure

To modify privileges on data objects in a physical data model:

  1. Select a physical data model data object in the Data Project Explorer or in a diagram, and open the Properties view.
  2. Use the Privileges tab to modify the privileges. If you used the Data Source Explorer to find the object, click the Image of Edit icon (Edit) icon on the toolbar in the Properties view. Use the grid and the toolbar buttons to add, modify, or revoke privileges. For database objects, use the check boxes to grant or revoke privileges for one or more of the listed authorization IDs:
    • Image of an empty check box The privilege is off
    • Image of a check box with one check mark The privilege is on without the ability to GRANT the privilege to others
    • Image of a check box with two check marks The privilege is on with the ability to GRANT the privilege to others
  3. Save the physical data model.

Results

Your changes are saved to the physical data model.

Feedback