获取oracle Sequence报错

siebel获取oracle Sequence报错

---------------------------
Siebel
---------------------------
An error has occurred writing to a record.  Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
ORA-00942: table or view does not exist 
---------------------------
确定   
---------------------------

查询log 报错如下：

SQLParseAndExecute Execute 5 0009c38051ff1933:0 2013-08-07 18:12:10 OCIStmtExecute: DML error or affected 0 rows
ObjMgrBusCompLog Error 1 0009c38051ff1933:0 2013-08-07 18:12:10 (oracon.cpp (3254)) SBL-DBC-00111: An error has occurred writing to a record.

原因：创建Sequence时缺少了grant语句。很低级的错误，可是起初不知道，折腾了半天。
-- Create sequence 
create sequence SIEBEL.HW_CUGID_SEQUENCE
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

解决办法：
grant select  on SIEBEL.HW_CUGID_SEQUENCE to sse_role;