Database Fundamentals/Security

From Wikiversity
Jump to navigation Jump to search

This lesson introduces database security.

Objectives and Skills[edit | edit source]

Objectives and skills for the database security portion of Microsoft Exam 98-364 Database Fundamentals include:[1]

  • Administer a database
    • Understand database security concepts
      • Understand the need to secure a database, what objects can be secured, what objects should be secured, user accounts, and roles

Readings[edit | edit source]

  1. Wikipedia: Database security

Multimedia[edit | edit source]

  1. Microsoft Virtual Academy: SQL Server Administration Fundamentals

Activities[edit | edit source]

Lesson Summary[edit | edit source]

  • Authentication is the act of confirming the truth of an attribute of a single piece of data (a datum) claimed true by an entity. [2]
  • Database security concerns the use of a broad range of information security controls to protect databases (potentially including the data, the database applications or stored functions, the database systems, the database servers and the associated network links) against compromises of their confidentiality, integrity and availability. [3]
  • In computer security, logging in, (or logging on or signing in or signing on), is the process by which an individual gains access to a computer system by identifying and authenticating themselves. [4]

Key Terms[edit | edit source]

authentication
database security
guest user
login
permission
sa account
server roles
sysadmin
user account

See Also[edit | edit source]

References[edit | edit source]

Nuvola apps edu miscellaneous.svg Type classification: this is a lesson resource.