Validate Database Privileges and Object Dependencies
Describes the post import validations for regular database usage and data access.
-
Invalid objects
-
Missing privileges
-
If the grant was not initiated or owned by the exported schema, then the grant will not carry over when the same schema is imported.
-
If another target schema that received a grant does not exist at the time of import, then the grant will not carry over successfully.
-
Any grants to
PUBLIC
will not carry over.
For example, consider a scenario where PDB_ADMIN
creates a new schema and grants EXECUTE
privilege to this schema on the default DBMS_CRYPTO
PL/SQL package. After exporting and importing the schema back into Exadata Express, EXECUTE
privilege on DBMS_CRYPTO
package can become invalid. Manually grant the privilege.