Oracle Database 12c R2: Administration - Lesson 06/11 PT-BR

Опубликовано: 02 Июнь 2026
на канале: Oráculo
242
9

Content of this lesson:
6. Lesson 5 Administering User Security
6.1 Objectives for Lesson 5
6.2 Creating Users
6.2.1 User Accounts
6.2.2 Oracle-Supplied Administrator Accounts
6.3 Granting Privileges
6.3.1 System Privileges
6.3.2 Object Privileges
6.4 Creating and Granting Roles
6.4.1 Granting Roles
6.4.2 Oracle-Supplied Roles
6.4.3 Making Roles More Secure
6.5 Revoking Privileges and Roles
6.5.1 Revoking System Privileges
6.5.2 Revoking Object Privileges
6.5.3 Revoking Roles
6.6 Creating and Assigning Profiles
6.6.1 Assigning Profiles
6.6.2 Password Parameters
6.6.3 Resource Parameters
6.6.4 Oracle-Supplied Password Verification Functions
6.7 Authenticating Users
6.7.1 Password Authentication
6.7.2 Password File Authentication
6.7.3 OS Authentication
6.8 Assigning Quotas to Users
6.9 Applying the Principal of Least Privilege
6.10 Summary for Lesson 5
6.11 Practice 5 Overview
6.11.1 Practice 5-1 Creating Common and Local Users
6.11.2 Practice 5-2 Creating a Local User for an Application
6.11.3 Practice 5-3 Granting the DBA Role to PDBADMIN
6.11.4 Practice 5-4 Creating a Local Profile in EM Express and Locking Accounts
6.11.5 Practice 5-5 Creating Local Roles in EM Express
6.11.6 Practice 5-6 Creating Local Users in EM Express
6.11.7 Practice 5-7 Configuring a Default Role for a User
6.11.8 Practice 5-8 Auditing User Activity
6.11.9 Practice 5-9 Exploring OS and Password File Authentication
7. Lesson 6 Creating and Managing Tablespaces
7.1 Objectives for Lesson 6
7.2 How Table Data Is Stored