Join Adam Wilbert for an in-depth discussion in this video Challenge: Creating a new user account, part of Database Foundations: Administration.
- For the first challenge of this course,…I'd like you to create a new user account…for a new hire at H Plus Active.…The user's name is Angela Hashton.…We'll want her to establish her own password…when she first logs in,…and she needs to have the ability…to create new databases on the server…as well as configure and shut down the server.…I estimate that creating the new user login…will take no more than five minutes.…Good luck!…
Author
Adam Wilbert
Released
11/3/2015Note: This course will also prepare certification candidates for the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
- Securing the database server
- Understanding Windows authentication vs. SQL Server authentication
- Assigning fixed server roles and fixed database roles
- Granting object-level permissions
- Understanding ownership claims
- Creating backups
- Restoring a database
Skill Level Beginner
Duration
Views
-
Introduction
-
Welcome1m 8s
-
What you should know1m 41s
-
-
1. Securing the Database Server
-
Securing the database server2m 40s
-
Creating a new Windows user4m 24s
-
2. Enforcing Database Roles
-
Managing password policies5m 45s
-
Assigning server roles3m 22s
-
-
3. Working with Fixed Database Roles
-
4. Assigning Database Object Permissions
-
Managing roles1m 46s
-
5. Creating Database Backups
-
Creating backups in SSMS1m 54s
-
Restoring a database in SSMS2m 12s
-
Conclusion
-
Next steps35s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Challenge: Creating a new user account