Validate Database Privileges and Object Dependencies

Describes the post import validations for regular database usage and data access.

Regardless of the source of the schema export and import, database object privileges and roles granted during normal database operation may not automatically carry over and some privileges can be missing causing invalid code.

After importing, verify such grants and if necessary, manually execute again. Ensure to check for the following:

• Invalid objects

• Missing privileges

The following are specific situations where grants do not carry over. To reproduce such grants, they must be re-executed after the import operation has completed:

• 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.