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.
Procedure
To revoke a privilege that exists on a data server:
- In the Data Project Explorer, right-click
the database in which the privilege is listed.
- On the Privileges page of the Properties
view, select the Revoke check box for the privilege
that you want to revoke.
- Right-click the database and select Generate DDL.
In the Generate DDL wizard, follow these steps:
- On the Options page of the wizard, deselect
all check boxes except Fully qualified names, Quoted
identifiers, and GRANT statements.
- On the Objects page, deselect all of
the check boxes.
- 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.
- On the Select Connection page, select
the connection to the data server.
- On the Summary page, verify the actions
that the wizard will perform and click Finish.
- In the Data Output view (which is by the Properties view by
default), verify that the SQL statements ran successfully on the data server.