Please Help me!

[SouthVN]

Hi All !

In my project, there is a request is how to can we know any user had
loged in to Oracle Database System, what's the time they log in, log
out ?; What did they do in database, example: insert, update, delete ?
; and which table did they insert, update, delete ?...

I don't know how to do this.
All Expert Oracle Please help me !
Thanks very much !

[Jim Kennedy]

Read the manual, the section on auditing.
Jim
"SouthVN" <np*******@yahoo.com> wrote in message
news:ee**************************@posting.google.c om...

Hi All !

In my project, there is a request is how to can we know any user had
loged in to Oracle Database System, what's the time they log in, log
out ?; What did they do in database, example: insert, update, delete ?
; and which table did they insert, update, delete ?...

I don't know how to do this.
All Expert Oracle Please help me !
Thanks very much !

[SouthVN]

Hi All !

I really don't know how to do that.

If every body know please give me a method to solve that proplem. or
please show me documents which to have a connection with it

Thanks very much !

South

[Jim Kennedy]

If you don't know how to read there isn't much I can do.
Go to otn.oracle.com and register and the look up the documentation.
Jim
"SouthVN" <np*******@yahoo.com> wrote in message
news:ee**************************@posting.google.c om...

Hi All !

I really don't know how to do that.

If every body know please give me a method to solve that proplem. or
please show me documents which to have a connection with it

Thanks very much !

South

[Ethel Aardvark]

If you are going to be so vague that you simply reply "read the
manual", don't be surprised if someone asks which one. There are a
vast number of manuals for Oracle (many of which are very poorly
written), if you are not even prepared to help people find the right
manual, I would suggest you do not reply to postings.

If you don't know how to think, there is not much YOU can do.

Kindest regards,

ETA

"Jim Kennedy" <ke****************************@attbi.net> wrote in message news:<4BjXa.59405$YN5.45528@sccrnsc01>...

If you don't know how to read there isn't much I can do.
Go to otn.oracle.com and register and the look up the documentation.
Jim
"SouthVN" <np*******@yahoo.com> wrote in message
news:ee**************************@posting.google.c om...

Hi All !

I really don't know how to do that.

If every body know please give me a method to solve that proplem. or
please show me documents which to have a connection with it

Thanks very much !

South

[KULJEET]

np*******@yahoo.com (SouthVN) wrote in message news:<ee**************************@posting.google. com>...

Hi All !

In my project, there is a request is how to can we know any user had
loged in to Oracle Database System, what's the time they log in, log
out ?; What did they do in database, example: insert, update, delete ?
; and which table did they insert, update, delete ?...

I don't know how to do this.
All Expert Oracle Please help me !
Thanks very much !

TRY IT --

SELECT V.PARSING_USER_ID,U.USERNAME,V.FIRST_LOAD_TIME,V.S QL_TEXT
FROM V$SQL V,ALL_USERS U
WHERE V.PARSING_USER_ID=U.USER_ID
ORDER BY V.FIRST_LOAD_TIME
BYE