jdbc 连接oracle执行sys.dbms_cdc_publish提示权限不足

0 0

jdbc 连接oracle执行sys.dbms_cdc_publish提示权限不足5

源代码 .
StringBuffer proc=new StringBuffer();
        proc.append("{call dbms_cdc_publish.create_change_set(");
        proc.append("change_set_name=>'test_test_hotlog',");
        proc.append("description=>'hotlog change set for test',");
        proc.append("change_source_name=>'HOTLOG_SOURCE',");
        proc.append("stop_on_ddl=>'y',");
        proc.append("begin_date=>sysdate,");
        proc.append("end_date=>sysdate+5)}");
        conn.prepareCallStatement(proc.toString());
        try {
            int result=conn.cstmt.executeUpdate();
            return result;
        } catch (SQLException ex) {
            this.errorMsg=ex.getMessage();
            return -1;
        }

错误信息:
java.sql.SQLException: ORA-01031: 权限不足
ORA-06512: 在 "SYS.DBMS_CDC_PUBLISH", line 560
ORA-06512: 在 line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:212)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:951)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1160)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4245)
at cn.xtu.exchange.cdc.Publish.executeUpdate(Publish.java:72)
at cn.xtu.exchange.cdc.Publish.createChangeSet(Publish.java:96)
at cn.xtu.exchange.cdc.Publish.createPublish(Publish.java:177)

这个用户我已经授权了,在sqlplus里面,可以正常执行