Manage users and privileges in Amazon RDS Custom for Oracle with Multitenant option

This article provides an in-depth guide to managing users and privileges in Amazon RDS Custom for Oracle with the Multitenant option. Key points include:

• Two types of user accounts: common and local users
• Common users can access multiple pluggable databases (PDBs)
• Local users are restricted to a single PDB
• AWS-managed accounts like C##RDSADMIN and C##RDS_DATAGUARD play critical roles
• Best practices for user management include:
  • Limit common users
  • Grant minimal necessary privileges
  • Implement strong security measures
  • Regularly audit user activities

The article emphasizes the importance of carefully managing user accounts and privileges in a multitenant Oracle database environment to ensure security and proper access control.