Expanded Library

Managing Users, Roles, and Privileges with Oracle

by Agaba Philip

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.

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

Ready to upskill? Get started