grant connect to test;
grant resource to test;
grant administer database trigger to test;
grant select on sys.obj$ to test;
grant select on sys.user$ to test;
grant select on sys.con$ to test;
grant select on sys.seq$ to test;
grant select on sys.tabpart$ to test;
grant select on sys.lobfrag$ to test;
grant select on sys.ind$ to test;
grant select on sys.icol$ to test;
grant select on sys.cdef$ to test;
grant select on sys.ccol$ to test;
grant select on sys.lob$ to test;
grant select on sys.tabcompart$ to test;
grant select on sys.tabsubpart$ to test;
grant select on sys.partcol$ to test;
grant select on sys.subpartcol$ to test;
grant select on sys.partobj$ to test;
grant select on sys.defsubpart$ to test;
grant select on sys.com$ to test;
grant select on sys.tab$ to test;
grant select on sys.coltype$ to test;
grant select on sys.type$ to test;
grant select on sys.attribute$ to test;
grant select on sys.collection$ to test;
grant select on sys.idnseq$ to test;
grant select on sys.deferred_stg$ to test;
grant select on sys.sum$ to test;
grant select on sys.snap$ to test;
grant select on sys.mlog$ to test;
grant select on sys.mlog_refcol$ to test;
grant select on sys.scheduler$job to test;
grant select on sys.recyclebin$ to test;
grant select on sys.col$ to test;
grant select on sys.ntab$ to test;
grant select on sys.external_tab$ to test;
grant select on v$parameter to test;
grant select on v_$instance to test;
grant select on v_$database to test;
grant select on v_$database_incarnation to test;
grant select on gv_$archive_dest to test;
grant select on gv_$instance to test;
grant select on gv_$parameter to test;
grant select on gv_$log to test;
grant select on gv_$logfile to test;
grant select on dba_cons_columns to test;
grant select on dba_constraints to test;
grant select on sys.trigger$ to test;
grant execute on dbms_flashback to test;
grant connect to test;
grant resource to test;
grant select on sys.obj$ to test;
grant select on sys.user$ to test;
grant administer database trigger to test;
grant select on sys.con$ to test;
grant select on sys.seq$ to test;
grant select on sys.tabpart$ to test;
grant select on sys.lobfrag$ to test;
grant select on sys.ind$ to test;
grant select on sys.icol$ to test;
grant select on sys.cdef$ to test;
grant select on sys.ccol$ to test;
grant select on sys.lob$ to test;
grant select on sys.tabcompart$ to test;
grant select on sys.tabsubpart$ to test;
grant select on sys.partcol$ to test;
grant select on sys.subpartcol$ to test;
grant select on sys.partobj$ to test;
grant select on sys.defsubpart$ to test;
grant select on sys.com$ to test;
grant select on sys.tab$ to test;
grant select on sys.coltype$ to test;
grant select on sys.type$ to test;
grant select on sys.attribute$ to test;
grant select on sys.collection$ to test;
grant select on sys.idnseq$ to test;
grant select on sys.deferred_stg$ to test;
grant select on sys.sum$ to test;
grant select on sys.snap$ to test;
grant select on sys.mlog$ to test;
grant select on sys.mlog_refcol$ to test;
grant select on sys.scheduler$job to test;
grant select on sys.recyclebin$ to test;
grant select on sys.col$ to test;
grant select on sys.ntab$ to test;
grant select on sys.external_tab$ to test;
grant select on v$parameter to test;
grant select on v_$instance to test;
grant select on v_$database to test;
grant select on v_$database_incarnation to test;
grant select on gv_$archive_dest to test;
grant select on gv_$instance to test;
grant select on gv_$parameter to test;
grant select on gv_$log to test;
grant select on gv_$logfile to test;
grant select on dba_cons_columns to test;
grant select on dba_constraints to test;
grant select on sys.trigger$ to test;
grant execute on dbms_flashback to test;
grant select any table to test;
grant select any dictionary to test;
grant lock any table to test;
grant select any sequence to test;
grant alter any sequence to test;
把用户名替换成实际的用户就可。