How to revoke statement permissions from users in a database (Enterprise Manager)
To revoke statement permissions from users in a database
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database containing the users from whom statement permissions will be revoked, and then click Properties.
- On the Permissions tab, select the statement permission to revoke from each user.
An empty box indicates a revoked permission.