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!