SCHEMA

[moeremanskarel]

Hey,

At this point Schema is not being logged. Depending on how the log happened it can be found in the column module or in session_user.

Can be useful if working with lots of schema's to have an extra column with this information.

Example: ALTER TABLE CONSOLE_LOGS ADD (used_schema VARCHAR2(50));

COMMENT ON COLUMN CONSOLE_LOGS.used_schema IS 'Schema';

:new.used_schema := sys_context('USERENV', 'CURRENT_SCHEMA');

Kind regards, Karel