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

Title: How to Grant Statement Permissions to Users within a Database in Microsoft SQL Server 2000

Objective: The objective of this demo is to teach you the process of granting statement permissions to users within a database in Microsoft SQL Server 2000. Activities involved in creating a database or an item in a database, such as a table or stored procedure, require a different class of permissions called statement permissions. For example, if a user must be able to create a table within a database, then grant the CREATE TABLE statement permission to the user. Statement permissions, such as CREATE DATABASE, are applied to the statement itself, rather than to a specific object defined in the database.

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