Revoking privileges for performing actions on data servers

Deleting privileges removes them only from a database in a data design project. Revoking privileges removes them from a data server.

About this task

The Privileges page of the Properties view for a database in a data design project only lists privileges. Deleting a privilege from that list does not automatically revoke that privilege from a data server.

1. In the Data Project Explorer, right-click the database in which the privilege is listed.
2. On the Privileges page of the Properties view, select the Revoke check box for the privilege that you want to revoke.
3. Right-click the database and select Generate DDL. In the Generate DDL wizard, follow these steps:
   1. On the Options page of the wizard, deselect all check boxes except Fully qualified names, Quoted identifiers, and GRANT statements.
   2. On the Objects page, deselect all of the check boxes.
   3. On the Save and Run DDL page, specify the name of the SQL file that the will wizard will create. Verify that the REVOKE statements are correct. Select the Run DDL on server check box.
   4. On the Select Connection page, select the connection to the data server.
   5. On the Summary page, verify the actions that the wizard will perform and click Finish.
   6. In the Data Output view (which is by the Properties view by default), verify that the SQL statements ran successfully on the data server.