Use the Data Object editor to modify privileges on data
objects, such as tables and views.
Procedure
To modify privileges on data objects:
- In the Data Source Explorer (or
the Object List for products that include this view), browse
to the object that you want to alter.
- Open the Data Object Editor using
one of the following methods:
- In the Data Source Explorer, right-click the data object,
and select Alter.
- In the
Object List, right-click the data object, and select Manage
Privileges.
The Data Object editor opens. Note: Other menu actions
on this object and its children in the explorer view, such as Refresh, Drop,
or Generate DDL, are disabled while the editor
is open.
- Use the Privileges tab
to modify privileges on this data object. Use the grid
and the toolbar buttons to add, modify, or revoke privileges. Press
F1 for additional information.
- Expand the Impacted Objects section
of the editor, and exclude impacted objects from the generated DDL
script.
The objects in the tree are potentially impacted
by changes to the object that you are altering. Typically when you
modify privileges, you do not include impacted objects in the DDL
script.
- Expand the DDL section
of the editor, and click Preview DDL.
If
you make additional changes in the Data Object Properties or Impacted
Objects sections, click Preview DDL again
to refresh the generated script.
You cannot type directly in
the DDL section of the editor. If you want to modify the generated
DDL script, click Open with SQL editor to open
the script in the SQL editor, where you can make changes and save
the script to an
existing data project. You can also use this option to save your
changes to an SQL script that you can run later.
- After you are satisfied with the generated
DDL script, click Run DDL in the Data
Object Properties section.
Results
The generated DDL script is run on the database,
and the data object and other impacted objects are modified according
to the changes that you made in the editor. The Data Output view displays
the results, including any errors that occurred. You can view the
changes in each data object by highlighting the object in the explorer
and opening the Properties view.