-- grant:
grant execute on sys.dbms_snapshot to %user;
grant CREATE DATABASE LINK to %user;
--grant select any dictionary to %user;
grant create snapshot to %user;
--grant execute on sys.XMLDOM to %user;
--grant execute on sys.dbms_snapshot to %user;
grant select on sys.dbms_lock_allocated to %user;
grant select on sys.v_$lock to %user;