This course shows users how to assign access and roles to server users and databases.
Objectives:
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 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
