Installation and Upgrade Guide

11.0
- 10.0

Back Next

Granting Privileges to the Oracle Database User

Grant privileges to the Oracle database user that you defined. Grant the user privileges that Fast Clone requires to connect to the Oracle database, retrieve source metadata, and unload data.

To perform a checkpoint before Fast Clone unloads the source data, grant the ALTER SYSTEM privilege or create a stored procedure.

To grant the ALTER SYSTEM privilege, issue the following statement:

GRANT ALTER SYSTEM TO FASTCLONE_USER;

To configure Fast Clone to use a stored procedure for checkpointing, perform the following steps:

Create the stored procedure. Use the following statements:

CREATE Procedure FastCloneCheckPoint
IS
BEGIN 
execute immediate 'ALTER SYSTEM CHECKPOINT GLOBAL'; 
END;

Grant the EXECUTE privilege to this stored procedure. Use the following statement:

GRANT EXECUTE ON FastCloneCheckPoint TO FASTCLONE_USER;

Edit the unload.ini file to use the stored procedure. You must add the non_standard_ckpt_block parameter. Use the following statement:

non_standard_ckpt_block="begin procedure_owner.FastCloneCheckPoint(); end;"

The user who owns and creates the stored procedure must have the ALTER SYSTEM privilege or DBA role.

To connect to the Oracle source database, grant the CREATE SESSION or CONNECT privilege. Use one of the following statements:

GRANT CREATE SESSION TO FASTCLONE_USER;
GRANT CONNECT TO FASTCLONE_USER;

To unload source data with the conventional path unload method, grant the SELECT ANY TABLE privilege. Use the following statement:

GRANT SELECT ANY TABLE TO FASTCLONE_USER;

You can grant the SELECT privilege on each source table that you want to unload instead of granting the SELECT ANY TABLE privilege.

To retrieve metadata about the structure of the source tables, grant the SELECT ANY DICTIONARY privilege. For Oracle 12
c
sources, also grant the SELECT privilege for the SYS.USER$ table. If the Oracle 12
c
sources use Oracle Transparent Data Encryption (TDE), grant the SELECT privilege on the SYS.ENC$ table too.

Grant the SELECT ANY DICTIONARY privilege. Use the following statement:

GRANT SELECT ANY DICTIONARY TO FASTCLONE_USER;

For Oracle 12
c
sources, grant the SELECT privilege for the SYS.USER$ table. Use the following statement:

GRANT SELECT ON SYS.USER$ TO FASTCLONE_USER;

For Oracle 12
c
sources that use Oracle TDE on columns and tablespaces, grant the SELECT privilege for the SYS.ENC$ table. Use the following statement:

GRANT SELECT ON SYS.ENC$ TO FASTCLONE_USER;

If you configure Fast Clone to lock the tables that are unloaded with the direct path unload method, grant the LOCK ANY TABLE privilege or grant the SELECT privilege on each table that you want to unload. Use one of the following statements:

GRANT LOCK ANY TABLE TO FASTCLONE_USER;
GRANT SELECT ON TABLE TABLE_NAME TO FASTCLONE_USER;

The SELECT ANY TABLE privilege is not sufficient to lock the source tables when unloading data.

If you also use Informatica Data Replication, grant the EXECUTE ON DBMS_FLASHBACK privilege. Use the following statement:

GRANT EXECUTE ON DBMS_FLASHBACK TO FASTCLONE_USER;

Fast Clone requires this privilege to get the current SCN of the source database.

Rename Saved Search

Table of Contents

Installation and Upgrade Guide

Installation and Upgrade Guide

Granting Privileges to the Oracle Database User

Granting Privileges to the Oracle Database User