Oracle Database Discussions

Hi,

I have a scenario where in Base table exists in one database and Materialized View on other.
The Materialized View is created with FAST REFRESH option.

I have created Materialized View Log in database where master table exists.
Also I have given Select priv on master table to the user(where MV is created).

I want to know how will i Grant SELECT PRIV on Materialized View Log so that FAST refresh happens.

Both databases are Oracle 10g R2.

I have read following on oracle site:
The owner of the materialized view must have the CREATE TABLE system privilege. The owner must also have access to any master tables of the materialized view that the schema owner does not own (for example, if the master tables are on a remote database) and to any materialized view logs defined on those master tables, either through a SELECT object privilege on each of the tables or through the SELECT ANY TABLE system privilege.

Please tell me the command to GRANT SELECT to the user who has created MV.

Thank You,
Niranjan.