problem in using dbms_snapshot.refresh to refresh snapshots

I have a "master" which controls snapshot creation, snapshot log creation and refresh of snapshots on master tables which are in other schema but same database (same db_host, port).

I am doing incremental refresh using the snapshot logs.

To refresh them, i am using dbms_snapshot.refresh('out_table', 'F');

But it throws insufficient privileges. I have the following privileges assigned to my "master" user:

GRANTED_ROLE                                 ADM
DEF          OS_


------------------------------ ------------------------------ --- ---

------------------------------------------

AQ_ADMINISTRATOR_ROLE                 NO                YES
NO
CONNECT                                            NO
YES         NO
RESOURCE                                         NO
YES         NO

 PRIVILEGE                                            ADM


------------------------------

---------------------------------------- ---

 DEBUG ANY PROCEDURE                      NO
CREATE ANY TRIGGER                            NO
ALTER ANY ROLE                                    NO
DELETE ANY TABLE                                NO
DEBUG CONNECT SESSION                    NO
CREATE SYNONYM                                 NO
DROP ANY INDEX                                    NO
ALTER ANY INDEX                                   NO
INSERT ANY TABLE                                 NO
ALTER ANY TABLE                                  NO
UNLIMITED TABLESPACE                        NO
CREATE VIEW                                         NO
DROP ANY MATERIALIZED VIEW             NO
SELECT ANY TABLE                                NO
CREATE MATERIALIZED VIEW                 NO
CREATE SEQUENCE                               NO
COMMENT ANY TABLE                           NO
DROP ANY TABLE                                  NO
QUERY REWRITE                                   NO
CREATE ANY MATERIALIZED VIEW        NO
CREATE DATABASE LINK                       NO
CREATE ANY INDEX                               NO
CREATE CLUSTER                                 NO
UPDATE ANY TABLE                              NO
CREATE ANY TABLE                              NO
ALTER SESSION                                     NO
CREATE SESSION                                  NO

Can a incremental refresh be done on snapshots on other user's master table? If yes, then what privilege is missing in the list? Please help. Thanks. Received on Tue Mar 04 2008 - 06:56:52 CST