Re: Help needed

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 07 Aug 2001 05:50:42 -0700
Message-ID: <F001.003628D0.20010807053042@fatcity.com>

Deewaker,
 you can run the listed srcipt to find the users that are connected to your server. With a little modification you can get all of the information you need. ROR mª¿ªm

+++++++++++++++++++++++++ user1.sql++++++++++

COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT COLUMN OSU FORMAT A8 HEADING 'SYSTEM|USER ID' JUSTIFY LEFT COLUMN STAT FORMAT A8 HEADING 'SESSION|STATUS' JUSTIFY LEFT COLUMN SSID FORMAT 999999 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT COLUMN SSER FORMAT 999999 HEADING 'ORACLE|SERIAL|NO' JUSTIFY RIGHT COLUMN SPID FORMAT A9 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT COLUMN TXT FORMAT A28 HEADING 'CURRENT STATEMENT' JUSTIFY CENTER WORD COLUMN LOGTIME FORMAT A10 HEADING 'LOGIN|TIME' JUSTIFY RIGHT SELECT
S.USERNAME SU,
S.OSUSER OSU,
to_char(S.LOGON_TIME,'MM-DD-YYYY HH:MI:SS') LOGTIME,

S.STATUS STAT,
S.SID SSID,
S.SERIAL# SSER,

LPAD(P.SPID,9) SPID,
SUBSTR(SA.SQL_TEXT,1,540) TXT
FROM V$PROCESS P,
V$SESSION S,
V$SQLAREA SA
WHERE P.ADDR=S.PADDR

AND S.USERNAME IS NOT NULL
AND S.SQL_ADDRESS=SA.ADDRESS (+)
AND S.SQL_HASH_VALUE=SA.HASH_VALUE (+)

ORDER BY 1,3,6;

+++++++++++++++++end user1.sql ++++++++++++++

>>> Deewaker_at_baazee.com 08/07/01 04:00AM >>>
HI DBA Guru's

It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple.... Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected.
The time when he/she executed the process What was the command given to execute the same..

Pls... Guruji's help me...

with warm regards,

Deewaker G. V.

Baazee.com India Pvt. Ltd.
*: 4611323 Extn: 216
Fax : 4611324

 <<Deewaker G.V..vcf>>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Aug 07 2001 - 07:50:42 CDT