Managing Users, Roles, and Privileges with Oracle
The Oracle database is the most popular relational database management system in the world. In this course, you will learn to understand the different kinds of user accounts in Oracle and authentication methods.
What you'll learn
If you work as an Oracle DBA, then it’s imperative that you understand how to administrate users, roles, and privileges in Oracle. In this course, Managing Users, Roles, and Privileges with Oracle, you'll start by learning to create and manage database user accounts, including tablespace quotas. First, you'll explore the granting and revoking system and object privileges. Next, you'll discover how to simplify privilege management using Roles. Finally, you'll learn to control resource usage through the use of Profiles. By the end of the course, you’ll be able to administer users, roles, privileges, database resource usage, as well as authentication in any Oracle database.
Table of contents
- Managing Users, Roles, and Privileges 0m
- Creating Accounts 2m
- System Privileges 2m
- Object Privileges 1m
- Demo: Privileges 4m
- Understanding Roles 6m
- Demo: Managing Roles 3m
- Using Profiles 3m
- Demo: Password Restrictions 1m
- Demo: Resource Limits 2m
- Password Strength 2m
- User Management in a Multitenant Environment 4m
- Authentication Methods 6m
- Summary 2m
About the author
I got my start in IT administrating an Oracle 10g database on Red Hat Linux. I've come a long way since and have used Linux everyday since 2012 both personally and professionally. As an independent consultant, I'm currently responsible for no less than forty Oracle databases running on Windows and Red Hat Servers. Perhaps the only thing I love almost as much as Linux is the Cloud and the many opportunities it provides. Linux has opened a lot of doors for me, and teaching it is my favorite pas... more