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!

privilege to create AWR and Statspack report to normal user

John-MKSep 26 2013 — edited Sep 26 2013

Hello,

I want to give right to one of the database user to create STATSPACK report in one database (no license there) and and to generate AWR report in other (licensed diagnostic+tuning pack).

Is there any privilege which I can give to create these reports only. I mean on a safe side ...

@?/rdbms/admin/spreport privilege to generate STATSPACK

@?/rdbms/admin/awrrpt privilege to generate AWR report.

Thanks a lot.

Best Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 24 2013

Added on Sep 26 2013

#general-database-discussions, #on

8 comments

2,974 views