why some table can not selected in report? (london)

[Wu Weikai1]

I want create a report to show "skiped upgrade history", but the table "Upgrade Details"( sys_upgrade_history_log) is not a choice in report. And I find the table which can select in report is different form which in sys_db_object.

report choice:

table in sys_db_object:

I want select the table "Upgrade Details" in report.

Can any one tell me how to do?

[The SN Nerd]

For a table to show in Reporting, it must pass a report_on ACL check.

If you want to report on that table, you have to create a new ACL against 'report_on' for that table.
You'll need to have security_admin to do this, and have security privileges enabled.

[Wu Weikai1]

Hi, Pual

Thank you for your reply.

As you said, I create a acl like:

However, I still can not find the table " sys_upgrade_history_log" in report.

Is there any mistake in acl?

[The SN Nerd]

• Check that you have the report_admin role
• Log in/out after applying ACL changes

[Wu Weikai1]

I checked the user role which I used.

like:

The account has the role "report_admin".

Then, I logout and login again.

But the table " sys_upgrade_history_log" is not showed in the report choices.