Hi Steve,

Here's a whitepaper that gives a good overview of the SQL 2000 RTM version security architecture and features:

http://www.microsoft.com/sql/techinfo/administration/2000/security/securityWP.asp

A revision covering SP3 and best practices is in the...