Total Time: 3 hour(s)

Summary: 
This course shows users how to assign access and roles to server users and databases.

Ojectives: 
After completing this course, students will be able to:
Assign SQL Server access through Windows NT accounts, SQL Server logins, and built-in administrator logins
Assign database access to Windows NT accounts, SQL Server login accounts, the Guest account, and the DBO user account
Create and assign SQL Server roles

Topics: 
Overview of SQL Server Security
Security Modes
Creating and Managing Logins
Database User IDs and Roles
Using the Create Login Wizard

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.