How to revoke statement permissions from users in a database (Enterprise Manager)

To revoke statement permissions from users in a database

1. Expand a server group; then expand a server.
2. Expand Databases, right-click the database containing the users to which statement permissions will be revoked, and then click Properties.
3. Click the Permissions tab.
4. Select the statement permission to revoke from each user. An empty box indicates a revoked permission.

See Also

Deactivating Established Access by Revoking Permissions