• Online, Self-Paced
Course Description

Discover how to control database access to specific objects and add new users with different levels of access privileges.

Learning Objectives

Oracle Database 12c R2 SQL: Controlling User Access

  • discuss the benefits of user access control
  • differentiate between system and object privileges
  • create a user and grant privileges
  • describe the purpose of a role
  • grant privileges to a role
  • change a password using the ALTER USER statement
  • list the various object privileges
  • pass on privileges using the WITH GRANT OPTION clause
  • confirm granted privileges
  • revoke privileges using the REVOKE statement
  • implement user access control

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.