From ssharma1@fcsltd.com Fri, 22 Jun 2001 04:09:32 -0700 From: "Saurabh Sharma" Date: Fri, 22 Jun 2001 04:09:32 -0700 Subject: Re: Auditing Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: Auditing why don't u create a separate tablespace for containing the audit information. it depends on ur requirements what level of auditing u want. and also what diff info u want to store.   create a separate tablespace and create the aud$ table in it by selecting from sys.aud$. when this is created drop from sys and create a synonym for it in sys.     saurabh
----- Original Message -----
From: Nirmal Kumar Muthu Kumaran To: Multiple recipients of list ORACLE-L Sent: Friday, June 22, 2001 4:11 PM Subject: RE: Auditing Hi Norrell, I just tested ur case. Can you tell me, how it's possible , when doing auditing, oracle will refer to the sys.aud$ table itself, correct?. If i droped it (even there is a synonym on that name), Oracle giving an error, it's not able to find the sys.aud$ table. Nirmal, -----Original Message----- From:   Norrell, Brian [SMTP:BNorrell@QuadraMed.com] Sent:   Thursday, June 21, 2001 6:33 PM To:     Multiple recipients of list ORACLE-L Subject:        RE: Auditing aud$ is one of the few system tables that can have an owner other than sys. You can create it under another schema (like system) and give sys a private synonym pointing to system.aud$.  Then put the trigger on the alternate aud$ create table system.aud$ as select * from sys.aud$; drop table sys.aud$; create synonym sys.aud$ for system.aud$; create trigger x on system.aud$ as ... Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -----Original Message----- Sent: Thursday, June 21, 2001 6:00 AM To: Multiple recipients of list ORACLE-L This will not work as you can't create triggers on sys objects. So tell me the way how i should create triggers on aud$. -----Original Message----- Sharma Sent: Thursday, June 21, 2001 2:56 PM To: Multiple recipients of list ORACLE-L i think u can use triggers such kind of auditing. create aud$ table with one more column, and try updating the column as soon user fires some sql. this is just a thought. could find another opinion. saurabh ----- Original Message ----- To: Multiple recipients of list ORACLE-L Sent: Thursday, June 21, 2001 11:15 AM > Hi all there, > I am auditing a database where 400 users are concurrently accessing the > database. > Now in the table AUD$ we have all the records of the user transactions.But > is there any way to store what sort of query he is running so that i can see > the actual text of query which was fired 3 days before. > Regards, > Anand > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Anand >   INET: karhadkar@rolta.com > > 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Saurabh Sharma   INET: ssharma1@fcsltd.com 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anand   INET: karhadkar@rolta.com 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Norrell, Brian   INET: BNorrell@QuadraMed.com 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@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).