Oracle Database 12c Security Cookbook

Chapter 2. Security Considerations in Multitenant Environment

In this chapter, we will cover the following tasks:

• Creating a common user
• Creating a local user
• Creating a common role
• Creating a local role
• Granting privileges commonly
• Granting privileges locally
• Granting common and local roles
• The effects of plugging/unplugging operations on users, roles, and privileges

Introduction

The Oracle multitenant environment is a new architecture of Oracle Database, introduced in version 12c (12.1.0.1). It brings major changes to the way Oracle Database administrators think about the concept of databases and how they work (in a multitenant environment). One of the most significant changes is that many databases (up to 252) can share one database instance.

This chapter ...