My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.2.0.3 [Release 8.1.7 to 11.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
Checked for relevance on 31-May-2013

Purpose

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

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

Scope

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

Details

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.