Logins, Users, Roles, and Groups
Logins, users, roles, and groups are the foundation for the security mechanisms of Microsoft® SQL Server™ 2000. Users that connect to SQL Server must identify themselves using a specific login identifier (ID). Users can then only see the tables and views they are authorized to see, and can only execute the stored procedures and administrative functions they are authorized to execute. This system of security is based on the IDs used to identify users.