The following Table gives you an Overview about the used DB-Tables

Name	Type	Description
LEHS_APPLICATIONS	Table	Here all Log-Applications are registered. Also the Exception Log-Level and the Switch to show the Application Name in the SQLERRM of raised Exceptions.
LEHS_APPLICATION_PRIVS	Table	Log-Application Privileges to DB-Uses and/or DB-Roles
LEHS_APPENDER	Table	All Log Appenders
LEHS_APPENDER_PARAMETERS	Table	All Log Appender Parameters
LEHS_LOG_LEVELS	Table	Free defined Log Levels to the Log-Applications
LEHS_LOG_LEVELS_PROGRAMMABLE	Table	Assignments of Log-Levels to programable Log-Levels to the Log-Applications
LEHS_TOPICS	Table	Log-Topics to the Log-Applications
LEHS_TRANSACTIONS	Table	Requested Log-Transactions to the Log-Applications and its State (OPEN or CLOSE)
LEHS_TRANSACTION_KEYS	Table	All additional Transaction Keywords, which have been added by PKG_LEHS.add_transaction_keys
LEHS_EXCEPTION_MESSAGES	Table	Exception Messages to the Log-Application
LEHS_LOG_TABLE_BASIC	Table	Log-Table for the Logs of the Log-Application 'Log-Application'
LEHS_TRANSACTION_SEQUENCE	Sequence	Sequence for the Log-Transactions
LEHS_LOG_TABLE_BASIC_SEQUENCE	Sequence	Sequence for the Log-ID of the Log-Application 'Log-Application' (used for the Field LOG_TABLE_BASIC.log_id)
LEHS_TOPICS_VIEW	View	Allowed Log-Topics
LEHS_LOGS_VIEW	View	Allowed Log-Entries
LEHS_LOG_LEVELS_VIEW	View	Allowed Log-Levels
LEHS_TRANSACTIONS_VIEW	View	Allowed Log-Transactions

By installing the Log-System the following Objects should be granted to the User PUBLIC

• PKG_LEHS (execute Package)
• PKG_WRAPPED_LEHS (execute Package)
• PKG_LEHS_FORMAT (execute Package)
• LEHS_APPLICATIONS_VIEW (Select View)
• LEHS_TOPICS_VIEW (Select View)
• LEHS_LOG_LEVELS_VIEW (Select View)
• LEHS_LOGS_VIEW (Select View)
• LEHS_TRANSACTION_VIEW (Select View)

• PKG_LEHS_SYSTEM (execute Package)
• LEHS_APPLICATIONS (Select Table)
• LEHS_APPLICATION_PRIVS (Select Table)
• LEHS_APPENDER (Select Table)
• LEHS_APPENDER_PARAMETERS (Select Table)
• LEHS_EXCEPTION_MESSAGES (Select Table)
• LEHS_LOG_LEVELS (Select Table)
• LEHS_LOG_LEVELS_PROGRAMMABLE (Select Table)

For any Appender Developers the following Objects should be directly granted to these Users

• PKG_LEHS_APPENDER (execute Package)

The following public Synonyms should be created

• CREATE PUBLIC SYNONYM pkg_lehs FOR LEHS.pkg_lehs
• CREATE PUBLIC SYNONYM pkg_wrapped_lehs FOR LEHS.pkg_wrapped_lehs
• CREATE PUBLIC SYNONYM pkg_lehs_format FOR LEHS.pkg_lehs_format
• CREATE PUBLIC SYNONYM pkg_lehs_system FOR LEHS.pkg_lehs_system
• CREATE PUBLIC SYNONYM lehs_logs FOR LEHS.lehs_logs_view
• CREATE PUBLIC SYNONYM lehs_topics FOR LEHS.lehs_topics_view
• CREATE PUBLIC SYNONYM lehs_transactions FOR LEHS.lehs_transaction_view
• CREATE PUBLIC SYNONYM lehs_applications FOR LEHS.lehs_applications
• CREATE PUBLIC SYNONYM lehs_application_privs FOR LEHS.lehs_application_privs
• CREATE PUBLIC SYNONYM lehs_appender FOR LEHS.lehs_appender
• CREATE PUBLIC SYNONYM lehs_appender_parameters FOR LEHS.lehs_appender_parameters
• CREATE PUBLIC SYNONYM lehs_available_applications FOR LEHS.lehs_applications_view
• CREATE PUBLIC SYNONYM lehs_exception_messages FOR LEHS.lehs_exception_messages
• CREATE PUBLIC SYNONYM lehs_log_levels FOR LEHS.lehs_log_levels
• CREATE PUBLIC SYNONYM lehs_log_levels_programmable FOR LEHS.lehs_log_levels_programmable