Join David Yahalom for an in-depth discussion in this video Create new database users, part of Oracle Database 12c: Security.
- [Narrator] Let's talk about Oracle Database Users…and how we can create them.…In an Oracle 12c Database we have two types of users…that are part of the multi-tenant architecture.…These are common users and local users.…In previous Oracle versions, we only had one type of user.…A local user account is a user account…that is created inside a PDB…and is local and unique to that PDB,…or Pluggable Database only.…
Let's see how we can create a local user in Oracle.…We will start by connecting to our ORCL PDB.…So I'll type:…sqlplus…sys slash Oracle…at orcl,…which is the name of the Pluggable Database,…as sysdba.…When connecting to a database from commandline utilities,…such as sqlplus, we specify the username…and the password of the user we want to connect with.…
The 'as sysdba' clause signifies that we are…connecting using the sysdba role.…Which we will talk about in further details…in the roles chapter of this course.…It is a special role that we need to specify…when opening a database connection…using the sysdba superuser.…
Author
David Yahalom
Released
11/15/2017Learn 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.
- Core concepts of Oracle database security
- Potential threats to Oracle database security
- Authentication and authorization
- Auditing access
- Data encryption
- Users and permissions
- Database roles
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 34s
-
What you need to know1m 26s
-
Exercise files1m 1s
-
-
1. Database Security Fundementals
-
2. Advanced Database Security Concepts
-
Database auditing3m 48s
-
Database encryption3m 44s
-
-
3. Download and Set Up the Course VM
-
Download the course VM5m 22s
-
Enable archive mode3m 6s
-
-
4. Users and Permissions
-
Create new database users6m 34s
-
Tablespace quotas5m 37s
-
Object permissions7m 39s
-
Password management policies7m 50s
-
Enforce password complexity6m 13s
-
Deleting a database user4m 48s
-
Creating local users6m 45s
-
Creating common users7m 1s
-
5. Database Roles
-
Roles with ADMIN OPTION3m 24s
-
6. Auditing Access to Data
-
Configure audit parameters5m 31s
-
Testing audit polices2m 34s
-
View the audit trail6m 2s
-
Using standard auditing5m 23s
-
Fine-grained auditing5m 56s
-
Manage the audit trail7m 23s
-
-
7. Data Encryption
-
Configure the keystore5m 23s
-
Create encryption key2m 23s
-
Encryping data in tables6m 30s
-
Encrypting tablespaces5m 7s
-
Encrypting Data Pump backups5m 55s
-
Encrypting RMAN Backups3m 55s
-
-
Conclusion
-
What's next?1m 46s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Create new database users