Oracle Database 12c R2 SQL: Controlling User Access

Oracle SQL 12c    |    Beginner
  • 11 videos | 37m 17s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 36 users Rating 4.6 of 36 users (36)
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

  • 4m 8s
    In this video, find out how to discuss the benefits of user access control. FREE ACCESS
  • 2m 7s
    In this video, learn how to differentiate between system and object privileges. FREE ACCESS
  • Locked
    3.  Granting Privileges
    2m 57s
    In this video, you will learn how to create a user and how to grant privileges. FREE ACCESS
  • Locked
    4.  Roles
    2m 22s
    Upon completion of this video, you will be able to describe the purpose of a role. FREE ACCESS
  • Locked
    5.  Granting Privileges to a Role
    2m 15s
    Learn how to give privileges to a role. FREE ACCESS
  • Locked
    6.  ALTER USER Statement
    2m 41s
    During this video, you will learn how to change a password using the ALTER USER statement. FREE ACCESS
  • Locked
    7.  Object Privileges
    3m 38s
    Upon completion of this video, you will be able to list the various object privileges. FREE ACCESS
  • Locked
    8.  WITH GRANT OPTION clause
    3m 51s
    To find out how to pass on privileges using the WITH GRANT OPTION clause. FREE ACCESS
  • Locked
    9.  Confirming Granted Privileges
    4m 16s
    Learn how to confirm privileges that have been granted. FREE ACCESS
  • Locked
    10.  REVOKE Statement
    3m 25s
    Learn how to revoke privileges using the REVOKE statement. FREE ACCESS
  • Locked
    11.  Exercise: Implement User Access
    5m 36s
    Find out how to implement user access control. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Channel MySQL
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Channel Access
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Journey 421 Database Administrator Advanced Certification Journey
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Oracle Database 12c R2 SQL: Creating Other Schema Objects
Rating 4.4 of 48 users Rating 4.4 of 48 users (48)
Course Oracle Database 12c R2 SQL: Manipulating Data Using Advanced Queries
Rating 4.4 of 33 users Rating 4.4 of 33 users (33)
Course Oracle Database 12c R2 SQL: Using the Set Operators
Rating 4.6 of 40 users Rating 4.6 of 40 users (40)