Granting PUBLIC System Role

The PUBLIC system role is a member of the SYS system role, and has read access for some of the system tables and views, so any user of the database can find out information about the database schema. If you want to restrict this access, you can revoke PUBLIC's membership in the SYS system role.

Any new user ID is automatically a member of the PUBLIC system role and inherits any permissions specifically granted to that role.

The WITH ADMIN OPTION or WITH ADMIN ONLY OPTION clauses are not valid when granting the diagnostics system role.