Re: Please Help me!

nphuongtt_at_yahoo.com (SouthVN) wrote in message news:<ee28214c.0307311927.126d9d77_at_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.SQL_TEXT

                                  FROM V$SQL V,ALL_USERS U 
                                  WHERE V.PARSING_USER_ID=U.USER_ID
                                  ORDER BY V.FIRST_LOAD_TIME

BYE Received on Wed Aug 06 2003 - 08:48:31 CEST