Oracle Database 12c R2 SQL: Controlling User Access

Oracle SQL 12c
  • 11 Videos | 42m 17s
  • Includes Assessment
  • Earns a Badge
Likes 16 Likes 16
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

CHANNEL Oracle Database 12c Administrator Certified Professional
Likes 27 Likes 27  
COURSE Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Likes 32 Likes 32  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 
Likes 19 Likes 19  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables
Likes 32 Likes 32  
COURSE Oracle Database 12c R2 SQL: Managing Objects with Data Dictionary Views 
Likes 19 Likes 19  
COURSE Oracle Database 12c R2 SQL: Using Basic SELECT statements
Likes 41 Likes 41