Modifying privileges to authorization IDs with the Data Object editor

Use the Data Object editor to modify privileges to authorization IDs, such as users or roles.
Before you modify privileges to authorization IDs, you must create a connection to a database in the Data Source Explorer.

To modify privileges to authorization IDs:

  1. Expand a database connection in the Data Source Explorer.
  2. Expand the folders in the connection and browse to the authorization ID (for example, a user or group) that you want to modify.
  3. Right-click the authorization ID, and click Alter.
  4. For data servers that support roles, click the Roles tab to grant or revoke role authorizations. Use the grid and the toolbar buttons to add, modify, or revoke role authorizations. Press F1 for additional information.
  5. Click the Privileges tab to modify individual privileges that are granted to this authorization ID.
  6. Expand the Impacted Objects section of the editor, and select impacted objects from the tree to include in the generated DDL script.

    The objects in the tree are potentially impacted by changes to the object that you are altering.

  7. 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, you must 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, you can 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.

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