| Object | Table Mode | User Mode | Full Database Mode | Tablespace Mode |
| Analyze cluster |
No |
Yes |
Yes |
No |
| Analyze tables/statistics |
Yes |
Yes |
Yes |
Yes |
| Application contexts |
No |
No |
Yes |
No |
| Auditing information |
Yes |
Yes |
Yes |
No |
| B-tree, bitmap, domain, functional indexes |
Yes |
Yes |
Yes |
Yes |
| Cluster definitions |
No |
Yes |
Yes |
Yes |
| Column and table comments |
Yes |
Yes |
Yes |
Yes |
| Database links |
No |
Yes |
Yes |
No |
| Default roles |
No |
No |
Yes |
No |
| Dimensions |
No |
Yes |
Yes |
No |
| Directory aliases |
No |
No |
Yes |
No |
| External tables (without data) |
Yes |
Yes |
Yes |
No |
| Foreign function libraries |
No |
Yes |
Yes |
No |
| Indexes ownerd by users other than table owner |
Yes (Privileged users only) |
Yes |
Yes |
Yes |
| Index types |
No |
Yes |
Yes |
No |
| Java resources and classes |
No |
Yes |
Yes |
No |
| Job queues |
No |
Yes |
Yes |
No |
| Nested table data |
Yes |
Yes |
Yes |
Yes |
| Object grants |
Yes (Only for tables and indexes) |
Yes |
Yes |
Yes |
| Object type definitions used by table |
Yes |
Yes |
Yes |
Yes |
| Object types |
No |
Yes |
Yes |
No |
| Operators |
No |
Yes |
Yes |
No |
| Password history |
No |
No |
Yes |
No |
| Postinstance actions and objects |
No |
No |
Yes |
No |
| Postschema procedural actions and objects |
No |
Yes |
Yes |
No |
| Posttable actions |
Yes |
Yes |
Yes |
Yes |
| Posttable procedureal actions and objects |
Yes |
Yes |
Yes |
Yes |
| Preshema procedural objects and actions |
No |
Yes |
Yes |
No |
| Pretable actions |
Yes |
Yes |
Yes |
Yes |
| Pretable procedural actions |
Yes |
Yes |
Yes |
Yes |
| Private synonyms |
No |
Yes |
Yes |
No |
| Procedural objects |
No |
Yes |
Yes |
No |
| Profiles |
No |
No |
Yes |
No |
| Public synonyms |
No |
No |
Yes |
No |
| Referential integrity constraints |
Yes |
Yes |
Yes |
No |
| Refresh groups |
No |
Yes |
Yes |
No |
| Resource costs |
No |
No |
Yes |
No |
| Role grants |
No |
No |
Yes |
No |
| Roles |
No |
No |
Yes |
No |
| Rollback segment definitions |
No |
No |
Yes |
No |
| Security policies for table |
Yes |
Yes |
Yes |
Yes |
| Sequence numbers |
No |
Yes |
Yes |
No |
| Snapshot logs |
No |
Yes |
Yes |
No |
| Snapshots and materialized views |
No |
Yes |
Yes |
No |
| System privilege grants |
No |
No |
Yes |
No |
| Table constraints (primary, unique, check) |
Yes |
Yes |
Yes |
Yes |
| Table data |
Yes |
Yes |
Yes |
No |
| Table definitions |
Yes |
Yes |
Yes |
Yes |
| Tablespace definitions |
No |
No |
Yes |
No |
| Tablespace quotas |
No |
No |
Yes |
No |
| Triggers |
Yes |
Yes |
Yes |
Yes |
| Triggers owned by other users |
Yes (Privileged users only) |
No |
No |
No |
| User definitions |
No |
No |
Yes |
No |
| User proxies |
No |
No |
Yes |
No |
| User views |
No |
Yes |
Yes |
No |
| User-stored procedures, packages, and functions |
No |
Yes |
Yes |
No |