HP IT/Operations and Oracle user grant issue

[Vince Laurent]

I am running Oracle 9.2.0.4 on HP-UX 11i. We are also trying to use
the HP Product IT/Operations. This one monitor we are having issues
with didn't have issues before I moved the database to locally managed
tablespaces.

Here is the command and the result (I had to hit CTRL+C to end it):

# ./dbspicao -v -c SSM2-DBSPI-Ora-15min -t SSM- -m 16

Instance: 'DEV' @ '/oracle/DEV/920_64'
-------------------------------------------------------------
04/07/05 12:03:06 WARNING dbspicao(20971) DEV
[metric0016:metric0016.pc:1379]:
DBSPI40-22: Error [ORA-01013: user requested cancel of current
operation] occurred executing dbms_space_admin - to fix as SYS do
'grant execute on sys.dbms_space_admin to <dbspiuser>'.

Well, I did grant the right but it still fails. Anyone have an idea?
Thanks
Vince
p.s. We did send this issue to HP but I'd figure I'd ask here
anyway...
-----------------------------------------------------
Come race with us!
http://www.mgpmrc.org