Oracle Database 12c R2 SQL: Controlling User Access


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description

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



Expected Duration (hours)
0.6

Lesson 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

    • Course Number:
    it_dfosfd_16_enus

    Expertise Level
    Beginner