Oracle Cloud Infrastructure Documentation

Grant Roles to the Oracle Data Safe Service Account on an Autonomous Database

To grant or revoke roles from the Oracle Data Safe service account on an Autonomous Database database, you can run the DS_TARGET_UTIL PL/SQL package on the Autonomous Database.

To grant or revoke roles from the Oracle Data Safe service account on an Autonomous Database:
  1. Using a tool like SQL*Plus or SQL Developer, log in to your Autonomous Database as the PDB Admin user (ADMIN) or as a user that has execute permission on the DS_TARGET_UTIL PL/SQL package.
  2. Grant or revoke a role from the Oracle Data Safe service account by running one of the following commands:
    EXECUTE DS_TARGET_UTIL.GRANT_ROLE(role_name);

    or

    EXECUTE DS_TARGET_UTIL.REVOKE_ROLE(role_name);

    where role_name is the name of an Oracle Data Safe role. See Roles for the Oracle Data Safe Service Account.