Oracle Database 12c R2 SQL: Controlling User Access

Oracle SQL 12c    |    Beginner
  • 11 Videos | 42m 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 User Security Features & Configuration
Likes 20 Likes 20  
COURSE Data Access & Permissions
Likes 110 Likes 110  
CHANNEL Oracle Database 12c Administrator Certified Professional
Likes 31 Likes 31  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Data Definition Language (DDL)
Likes 33 Likes 33  
COURSE Relational Database Concepts
Likes 223 Likes 223  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 
Likes 28 Likes 28