Reports: Tables and Views

| Field Descriptions | Related Help Topics | Additional Information |

Use this page to choose the database tables or views on which you want to base the report.

Field Descriptions

Field	Description
Tables or Views	Choose the tables or views whose data will be used to create the report. The list contains: Tables, views, and synonyms in the provider schema where you have SELECT, INSERT, UPDATE, or DELETE privileges. Tables, views, and synonyms where SELECT has been granted to public users. All public synonyms. The table name in the list is prefixed by the schema that owns it. For example, a table named EMP in the SCOTT provider appears in the list as SCOTT.EMP.

Field

Description

Tables or Views

Choose the tables or views whose data will be used to create the report. The list contains:

Tables, views, and synonyms in the provider schema where you have SELECT, INSERT, UPDATE, or DELETE privileges.
Tables, views, and synonyms where SELECT has been granted to public users.
All public synonyms.

The table name in the list is prefixed by the schema that owns it. For example, a table named EMP in the SCOTT provider appears in the list as SCOTT.EMP.

Notes

You automatically have SELECT, INSERT, UPDATE, or DELETE privileges on a table or view if it is in the provider schema where you have been granted privileges to build portlets.

Additional Information

On Portal Center:

For more information go to the documentation section of Portal Center.

Reports: Tables and Views

Field Descriptions

Notes

Related Help Topics

Next Steps:

Additional Information

On Portal Center: