A new demo has been added in the SQL Server 2000 demo portion.The detail of this demo is

Title: How to Prevent Access by Denying Permissions in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of preventing access by denying permission on an object in Microsoft SQL Server 2000. Microsoft SQL Server allows Microsoft Windows users and groups, SQL Server users, and SQL Server database roles to be members of other roles. This results in a hierarchical security system that allows permissions to be applied through several levels of roles and members. But there may be times when you want to limit the permissions of a user or role.

If you are a subscriber, then click the Demos link in the navigation menu to view the complete list of demos.