Assign a Role to Backup

To assign a role to a RiskVision schema user:

1. Start SQL*Plus or any other tool that is available to run SQL commands.

2. Connect the database, then execute the following grant command:

   SQL><schema_user>/<password>@<tns_alias> as sysdba

   SQL>Grant exp_full_database to agl_owner

   When you finish assigning the role, you can execute the expdp command to accomplish the backup job.

   Besides using the expdp command, you can also use the exp command to back up the Oracle database. Note that the exp command only supports a few datatypes that are available in Oracle Database 12c. Due to this limitation, we recommend using the expdp command instead.