How to deny statement permissions from users within a database (Enterprise Manager)

SQL Server Setup Help

SQL Server Setup Help

How to deny statement permissions from users within a database (Enterprise Manager)

To deny statement permissions from users within a database

  1. Expand a server group, and then expand a server.

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

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

    An 'X' indicates a denied permission.

See Also

Denying Permissions