Table 23-1 lists the privileges required to import objects into your own schema. All of these privileges initially belong to the RESOURCE
role.
Table 23-1 Privileges Required to Import Objects into Your Own Schema
Object | Required Privilege (Privilege Type, If Applicable) |
---|---|
Clusters |
|
Database links |
|
Triggers on tables |
|
Triggers on schemas |
|
Indexes |
|
Integrity constraints |
|
Libraries |
|
Packages |
|
Private synonyms |
|
Sequences |
|
Snapshots |
|
Stored functions |
|
Stored procedures |
|
Table data |
|
Table definitions (including comments and audit options) |
|
Views |
|
Object types |
|
Foreign function libraries |
|
Dimensions |
|
Operators |
|
Indextypes |
|