My Oracle Support Banner

PUBLIC : Is it a User, a Role, a User Group, a Privilege ? (Doc ID 234551.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


This bulletin explains what kind of entity is PUBLIC in a database.

PUBLIC : a user , a group , a role , a privilege ?


For all users of any kind in a database: DBAs, Developers, End-Users, Schemas

A- Definition and Visibility
B- Usage of PUBLIC role
C- Impact on ALL_xxx Views
D- Granting and Revoking to/from PUBLIC
E- PUBLIC and Private Objects and Segments
F- PUBLIC Privileges
G- Resource Manager


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.