Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

statspack errors

1003614Oct 1 2013 — edited Oct 7 2013

Hi All,

oracle 9.2.0.8.0

Linux

STATSPACK.STAT_CHANGES

ERROR at line 2:

ORA-06550: line 2, column 3:

PLS-00904: insufficient privilege to access object PERFSTAT.STATSPACK

ORA-06550: line 2, column 3:

PL/SQL: Statement ignored

am getting above error while generating statspack report.actually am using another(CGUA) user other than perfstat user , but user CGUA has SELECT_CATALOG_ROLE......

is this enough or do i need to GRANT EXECUTE ON statspack TO CGUA; and GRANT SELECT ON <every_table_under_perfstat> TO CGUA;

please suggest?

thanks,

Mike.

This post has been answered by 1003614 on Oct 7 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 4 2013

Added on Oct 1 2013

#general-database-discussions

2 comments

498 views