Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Oracle Database 12c: Security

Oracle Database 12c: Security

3h 39mIntermediate2017-11-15

Authors

David Yahalom

David Yahalom

Certified Database Expert and Cloud Solutions Architect

Course details

Database security is one of the hottest topics for Oracle DBAs, and one of the most important aspects of their role. With the increasing risks of cyberattacks, database hacks, and data leaks, knowing how to fully enable and leverage all of the Oracle 12c security features is essential. In this course, Oracle instructor and consultant David Yahalom covers this vitally important and in-demand skill.
Learn how to identify the major risks and security threats, and review general best practices for properly protecting and "hardening" any production database. Then, dive into hands-on demos that show how to set up user accounts, the connection between users and schemas, database object and system permissions, and roles in a multitenant environment, as well as encrypt data, audit user actions, and access to sensitive information. Plus, find out how to enable data-at-rest security via the Oracle Transparent Data Encryption and backup encryption options.

Learning objectives
Core concepts of Oracle database security
Potential threats to Oracle database security
Authentication and authorization
Auditing access
Data encryption
Users and permissions
Database roles

Skills covered

Oracle DatabaseDatabase AdministrationOracleDatabase ManagementDeep Dive (X:Y)

Concepts

0. Introduction

  • 01 - Welcome
  • 02 - What you need to know
  • 03 - Exercise files

1. Database Security Fundementals

  • 04 - Why database security is important
  • 05 - Authentication an database users
  • 06 - Authorization and permissions

2. Advanced Database Security Concepts

  • 07 - Database auditing
  • 08 - Database encryption
  • 09 - Roles of DBAs in Oracle security

3. Download and Set Up the Course VM

  • 10 - Download the course VM
  • 11 - Enable archive mode

4. Users and Permissions

  • 12 - Users, schemas, and the SYSDBA
  • 13 - Create new database users
  • 14 - Grant and evoke system privileges
  • 15 - Grant database-wide system privileges
  • 16 - Tablespace quotas
  • 17 - Object permissions
  • 18 - Password management policies
  • 19 - The WITH GRANT and WITH ADMIN options
  • 20 - Enforce password complexity
  • 21 - Viewing users, permissions, and polices
  • 22 - Deleting a database user
  • 23 - Local vs. common user concepts
  • 24 - Creating local users
  • 25 - Creating common users
  • 26 - Separating object owners and access

5. Database Roles

  • 27 - Introduction to database roles
  • 28 - Creating, assigning, and dropping roles
  • 29 - Viewing existing roles and role grants
  • 30 - Roles with ADMIN OPTION

6. Auditing Access to Data

  • 31 - Configure audit parameters
  • 32 - Creating unified audit policies
  • 33 - Testing audit polices
  • 34 - View the audit trail
  • 35 - Using standard auditing
  • 36 - Fine-grained auditing
  • 37 - Manage the audit trail

7. Data Encryption

  • 38 - Configure the keystore
  • 39 - Create encryption key
  • 40 - Encryping data in tables
  • 41 - Encrypting tablespaces
  • 42 - Encrypting Data Pump backups
  • 43 - Encrypting RMAN Backups
  • 44 - Restore encrypted RMAN Backup
  • 45 - Open the wallet after DB restart

Conclusion

  • 46 - What's next

Related courses

Related learn paths

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal