How to deny statement permissions from users within a database (Enterprise Manager)
SQL Server 2000
To deny statement permissions from users within a database
- Expand a server group, and then expand a server.
- Expand Databases, right-click the database containing the users to whom statement permissions will be denied, and then click Properties.
- On the Permissions tab, select the statement permission to deny each user.
An 'X' indicates a denied permission.