Oracle Database 12c R2 SQL: Controlling User Access

Oracle SQL 12c    |    Beginner
  • 11 Videos | 37m 17s
  • Includes Assessment
  • Earns a Badge
Likes 34 Likes 34
Discover how to control database access to specific objects and add new users with different levels of access privileges.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Oracle Database 12c R2 SQL: Using the Set Operators
Likes 28 Likes 28  
COURSE Java: Accessing Constructors, Methods, & Fields Using Reflection
CHANNEL SQL Database Development & Design
Likes 231 Likes 231  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Conversion Functions & Conditional Expressions
Likes 39 Likes 39  
COURSE Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 72 Likes 72  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views
Likes 28 Likes 28