OraFAQ Forum: Security » LogMiner doesn't show username

Home » RDBMS Server » Security » LogMiner doesn't show username

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

LogMiner doesn't show username [message #187065]

Thu, 10 August 2006 14:03

kekabuk
Messages: 4
Registered: August 2006

Junior Member

Hi,

I'm trying to make some audit using Oracle LogMiner. The problem is I need the username to be shown and the query is not returning it! Someone knows why I can't see the username when I query v$logmnr_contents ??

select USERNAME, OPERATION ,SQL_REDO from v$logmnr_contents where seg_owner = 'TOMAS';

USERNAME OPERATION   SQL_REDO
-------- ---------- --------------------
         DELETE      delete from "TOMAS"
                     ."PR_PEOPLE_CAT
                     EGORY" where "EMP
                     _NO" = 'T088389' and
                     "SS_ID" = '087889' and
                     "EMP_CATEGORY" =
                     '43' and "START_DATE"

Report message to a moderator

Re: LogMiner doesn't show username [message #188400 is a reply to message #187065]

Fri, 18 August 2006 06:47

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Was the user created after you've enabled logminer. If so, try to enable DDL Dictionary Tracking.

EXEC DBMS_LOGMNR.start_logmnr(options=>Dbms_Logmnr.DDL_Dict_Tracking);

Report message to a moderator

Re: LogMiner doesn't show username [message #188414 is a reply to message #188400]

Fri, 18 August 2006 08:04

kekabuk
Messages: 4
Registered: August 2006

Junior Member

The user was created before I implemented LogMiner...

Report message to a moderator

Re: LogMiner doesn't show username [message #188484 is a reply to message #188414]

Fri, 18 August 2006 13:29

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try to enable supplemental logging. That should "force" the database to capture additional info (including the username).

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE INDEX) COLUMNS;

Report message to a moderator

Re: LogMiner doesn't show username [message #188491 is a reply to message #188484]

Fri, 18 August 2006 14:06

kekabuk
Messages: 4
Registered: August 2006

Junior Member

hum... before I try this, can you tell me if supplemental logging increases too much the size of redo log files and if there is any impact to database performance, please...

Report message to a moderator

Re: LogMiner doesn't show username [message #188498 is a reply to message #188491]

Fri, 18 August 2006 15:08

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Good question. It depends on your implementation.

Supplemental logging will cause Oracle to log more data to the redo logs. If your application uses primary and unique keys, the overhead should be minimal. If not, Oracle will have to log all columns to the redo logs.

Why don't you test it and report back on your findings?

Report message to a moderator

Re: LogMiner doesn't show username [message #189910 is a reply to message #187065]

Mon, 28 August 2006 07:55

kekabuk
Messages: 4
Registered: August 2006

Junior Member

I've tested on my test development environment last week and I still didn't feel any diferences related with the performance, and my problem was solved! I'll just wait a few more days to start supplemental logging on my production enviroment.
Thanks for your help Frank !!

Report message to a moderator

Previous Topic:	granting privileges
Next Topic:	problem with password verify function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 18:00:14 CDT 2024