Oracle9iAS Portal Developer Kit

Secured logging views

In the wwlog_api_admin API package, table views that correspond to the wwlog_activity_logs view are created to expose the log records for a single sub-domain, according to the current user's security access privilege.

These views are granted to public users so that the reports and charts used for monitoring can be based on them.

Logging table views and definitions

wwlog_portal_
admin_logs

Includes all log record data. This view contains records only if the user has the Oracle Portal Administrator role.

wwlog_user_
logs

Includes all logs created by the current user.

wwlog_all_
page_logs

Includes pages the current user can view.

wwlog_all_
portlet_logs

Includes portlet instances on pages current user can view.

wwlog_all_
document_logs

Includes documents the current user can view.

wwlog_all_
folder_logs

Includes all folders the current user can view.

wwlog_all_
category_logs

Includes all categories the current user can view

wwlog_all_
perspective_logs

Includes perspectives the current user can view.

wwlog_all_
search_logs

Includes searches the current user can view.

wwlog_all_
item_logs

Includes items the current user can view.

wwlog_all_
user_logs

Includes logs for all users and may be viewed by Oracle Portal administrators and users who have at least ANY_USER/CREATE privileges.

wwlog_all_
group_logs

Includes groups the user owns, or all groups if the user has the Oracle Portal Administrator role.

wwlog_all_
component_logs

Includes all components the current user can view.

wwlog_all_
object_logs

A summary view that includes all the above views

 

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio