Modifying privileges on data objects with the Data Object editor

Use the Data Object editor to modify privileges on data objects, such as tables and views.
Before you modify privileges on data objects, you must create a connection to a database in the Data Source Explorer.

To modify privileges on data objects:

  1. Expand a database connection object in the Data Source Explorer.
  2. Expand the folders inside the database connection and browse to the object that you want to alter.
  3. Right-click the data object, and select Alter. If the Alter action is not available, then the object that you selected is not supported for editing. The Data Object editor opens.
    Note: Other menu actions on this object and its children in the Data Source Explorer, such as Refresh, Drop, or Generate DDL, are disabled while the editor is open.
  4. Click 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.
  5. 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.

  6. 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.

  7. After you are satisfied with the generated DDL script, click Run DDL in the Data Object Properties section.
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 Data Source Explorer and opening the Properties view.

Feedback