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

BOOK Snowflake Access Control: Mastering the Features for Data Privacy and Regulatory Compliance
COURSE Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Likes 34 Likes 34  
COURSE Microsoft Azure Administrator: Role-based Access Control
Likes 1 Likes 1  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Working with DDL
Likes 241 Likes 241  
COURSE Restricting Output
Likes 93 Likes 93  
COURSE Oracle Database 12c R2 SQL: Using Structured Query Language (SQL)
Likes 268 Likes 268