Configuring Access Privileges - On-premise deployments only

Archiving data to another database schema is achieved when access privileges are granted.

Another Database Schema (ARCHIVE_MODE=SCHEMA)

The archive schema must provide privileges to the core schema to:

  • Select from any table in the archive schema mode.
  • Insert into any table in the archive schema mode.

The following example illustrates how access privileges are provided to the core schema in Oracle:

CREATE USER ARCHIVE IDENTIFIED BY VALUES '679459CE431927F9'
    DEFAULT TABLESPACE USERS                  
    TEMPORARY TABLESPACE TEMP                                 
    PROFILE DEFAULT                              
    ACCOUNT UNLOCK              
/
GRANT "CONNECT" TO ARCHIVE
/
GRANT "RESOURCE" TO ARCHIVE
/
ALTER USER ARCHIVE DEFAULT ROLE "CONNECT",
                                "RESOURCE"
/
GRANT ALTER ANY TABLE TO ARCHIVE
/
GRANT CREATE ANY INDEX TO ARCHIVE
/
GRANT CREATE ANY TABLE TO ARCHIVE
/
GRANT DROP ANY TABLE TO ARCHIVE
/
GRANT GRANT ANY PRIVILEGE TO ARCHIVE
/