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

SQL Server Setup Help

SQL Server Setup Help

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, and then expand a server.

  2. Expand Databases, right-click the database containing the users from whom statement permissions will be revoked, and then click Properties.

  3. On the Permissions tab, select the statement permission to revoke from each user.

    An empty box indicates a revoked permission.

See Also

Revoking Permissions