By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,321 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,321 IT Pros & Developers. It's quick & easy.

Please Help me!

P: n/a
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 !
Jul 19 '05 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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 !

Jul 19 '05 #2

P: n/a
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
Jul 19 '05 #3

P: n/a
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

Jul 19 '05 #4

P: n/a
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

Jul 19 '05 #5

P: n/a
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
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.