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:
- Select a physical data model data object in the Data Project Explorer
or in a diagram, and open the Properties view.
- Use the Privileges tab
to modify the privileges. If you used the Data Source Explorer to
find the object, click the
(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:
The privilege is off
The privilege is
on without the ability to GRANT the privilege to others
The privilege is
on with the ability to GRANT the privilege to others
- Save the physical data model.
Results
Your changes are saved to the physical data model.