linkedin
5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707
support@lambers.com

SkillSoft Explore Course

BUY NOW! STARTING AT ONLY $299!
Certification     Oracle     Oracle Database 12c Administrator Certified Associate     1Z0-071 Oracle Database 12c R2: SQL Fundamentals

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

Asset ID it_dfosfd_16_enus
Course Type Video Course
Course Category Oracle
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