Hi Paul,
Have a look at the paper i wrote for security focus a few months ago,
called An Introduction to simple Oracle auditing - there is a link to
it on my site - http://www.petefinnigan.com/orasec.htm - its the second
paper on there. It is not in-depth but concentrates on the benefits of
just
Pete,
I readyour paper before I turned auditing on (in the first place). I've spent many an evening reading papers posted on your site and on the sans.org site.
I haven't picked up your book in awhile, but I'm due to do so in updating our install docs for Oracle 9i on w2k3 svr. Has content been
Hi Paul,
Thanks for your reply. The Oracle security step-by-step is available on-
line from SANS but only as departmental licenses and unlimited licenses
at present. The code from the book is available on my website
http://www.petefinnigan.com - look under the page about the book. Also I
have
Hi.
I just wanted to plug the use of auditing.
By simply enabling audit session, I detemined that users that were accessing a database via a vpn connection were being timed out (LOGOFF BY CLEANUP). It wasn't the application that was causing the apparent hangs, it was the network. How bout
Hear, hear, Paul!
I too, am a big fan of auditing.
It can make your life so
much easier.
Cheers,
Melanie
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Paul
Drake
Sent: Tuesday, October 07, 2003 8:14 PM
To: Multiple recipients
Greetings and Salutations!
At the direction of the external auditors I have been instructed to
install/configure oracle auditing in our Oracle Applications databases.
(sweet!) The next step is to estimate how much space all of the auditing
information will take. (I plan on moving the data from
Kevin Toepke scribbled on the wall in glitter crayon:
Can anyone out there in oracle-l land help me give a reasonable
estimate?
billions and billions.;-)
--
Bill Shrek ThaterOracle DBA BAARF Party member #25
[EMAIL PROTECTED]
-
From: Kevin Toepke [mailto:[EMAIL PROTECTED]
Sent: 18 June 2003 14:50
To: Multiple recipients of list ORACLE-L
Subject: Oracle Auditing
Greetings and Salutations!
At the direction of the external auditors I have been instructed to
install/configure oracle auditing in our Oracle
Kevin,
It widely depends on what you are auditing, and how (eg per access / per session).
If it's per access (certainly an overkill) a sum(executions) from v$sql group by
command_type can put you on the right tracks for the number of records you may expect
(check also the oldest loading
[EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
-Original Message-
From: Kevin Toepke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L
Subject: Oracle Auditing
Greetings and Salutations!
At the direction
bepretty small
(grin!)peter -Original Message- From:
Kevin Toepke [mailto:[EMAIL PROTECTED]
Sent: 18 June 2003 14:50 To: Multiple recipients of list
ORACLE-L Subject: Oracle Auditing Greetings
and Salutations! At the direction of the external auditors I
have been instructed to install
, Rich
Sent: Wednesday, June 18, 2003 10:19 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Oracle Auditing
From our production ERP DB:
SELECT MIN(timestamp), MAX(timestamp), AVG(rowsperday),
SUM(rowsperday)
FROM
(
SELECT TRUNC(timestamp) TIMESTAMP, COUNT(*) ROWSPERDAY
FROM dba_audit_trail
AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Database Auditing
Ravindra,
I'm not sure I understand the question correctly. Statement
level auditing?
Are you referring to recording that a particular statement
was executed on a
specific table? If so, the plain vanilla AUDIT
Subject: Re: Database Auditing
Ravindra,
I'm not sure I understand the question correctly. Statement
level auditing?
Are you referring to recording that a particular statement
was executed on a
specific table? If so, the plain vanilla AUDIT statement is
for you. There
is no need
Hi All,
How do we turn on statement level auditing (DB and OS Level) to audit the
DML/DDL's on the database.Is this possible with out triggers?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Basavaraja, Ravindra
INET: [EMAIL PROTECTED]
Fat City Network
on statement level auditing (DB and OS Level) to audit the
DML/DDL's on the database.Is this possible with out triggers?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858
Ravindra,
I'm not sure I understand the question correctly. Statement level auditing?
Are you referring to recording that a particular statement was executed on a
specific table? If so, the plain vanilla AUDIT statement is for you. There
is no need for any triggers to be set up.
If you want more
not
use the database. My plan is this:
Turn on session auditing (See below for potential
problem)
After a couple of months, determine which users have
never logged into the database
Lock or drop the accounts of these users
I was about to turn on auditing when I realized
Title: RE: Script to Turn Off All Oracle Auditing Options?
To create the audit trail views, run cataudit.sql.
To delete the audit trail views, run catnoaud.sql.
To find out which are the active options, use this statement:
SELECT * FROM sys.dba_priv_audit_opts;
or for audit options
In my previous message, I forgot to say:
You could always use the scorched earth approach and change everyone's
password. Then see who complains that they can't log in. :)
-Original Message-
We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version
2.3.4.0.0.
I have a
I see yet another poor soul still supporting V7.3.4.5 as I am doing on V2.6
Solaris.
You should be warned that on a couple of different occasions (I'm a slow
learner)
when I launched a SQL script which changed AUDITing on hundreds of objects,
Oracle went bonkers. It appearded as though
...um, if you say so. That really didn't answer my question, though...
I hope that your solution did not include assigning users SYSDBA privileges
in order to merely track/audit them?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November
Hello All,
Do any of you have suggestions for a good way to monitor sysdba user
activities on the sys.aud$ table? Or, in terms of logging everything, what
would be the keypoints to log scrub on?
Any suggestions would be wonderful.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-Original Message-
From: Dana Mueller
Sent: Monday, November 18, 2002 11:45 AM
To: '[EMAIL PROTECTED]'
Subject: sys.aud$ - auditing user activities?
Hello All,
Do any of you have suggestions for a good way to monitor sysdba user
activities on the sys.aud
SYSDBA activities are not logged to the SYS.AUD$ table, even in Oracle9i
with the AUDIT_SYS_OPERATIONS parameter set to TRUE. SYSDBA operations are
always logged to the OS audit trail, including access/modifications to the
SYS.AUD$ table...
The reason that these records are only logged to the
Tim - Thanks for the well worded response. Very, very helpful.
So my next question: Are there any 3rd party applications available to do
what Oracle won't?
-Original Message-
Sent: Monday, November 18, 2002 4:29 PM
To: Multiple recipients of list ORACLE-L
SYSDBA activities are not
please be a little more specific? what exactly is it that oracle won't do?
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 18, 2002 7:58 PM
Tim - Thanks for the well worded response. Very, very helpful.
So my next question:
Tim / All.
I figured it out.
Basically assign users SYSDBA privies and track accordingly.
-Original Message-
Sent: Monday, November 18, 2002 7:44 PM
To: Multiple recipients of list ORACLE-L
please be a little more specific? what exactly is it that oracle won't do?
- Original
, 2002 10:41 AM
Is there a way of capturing info on people who issue CREATE DATABASE
statements?
My Oracle Support technician says auditing won't catch this, only catches
successful attempts.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et
Is there a way of capturing info on people who issue CREATE DATABASE
statements?
My Oracle Support technician says auditing won't catch this, only catches
successful attempts.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
]
Sent: Thursday, October 17, 2002 10:41 AM
Is there a way of capturing info on people who issue CREATE DATABASE
statements?
My Oracle Support technician says auditing won't catch this, only catches
successful attempts.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin
: Thursday, October 17, 2002 12:42 PM
To: Multiple recipients of list ORACLE-L
Subject: auditing CREATE DATABASE
Is there a way of capturing info on people who issue CREATE DATABASE
statements?
My Oracle Support technician says auditing won't catch this,
only catches
successful attempts
Um... wasn't this...
Then you go and publicly execute that
person by beating him to the pulp with a baseball bat (so called Soprano
method)
...the Al Capone method in The Untouchables?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara,
-
From: Tim Gorman [mailto:Tim;SageLogix.com]
Sent: Thursday, October 17, 2002 1:51 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: auditing CREATE DATABASE
What a tongue-in-cheek answer: only catches successful
attempts! I like
his/her sense of humor...
Issuing a CREATE
is that there have been some
unexplained changes to data that have occurred over the last month that is
causing a pile of concern. It is believed that someone who has the schema
password is using SQL*Plus or Toad to update the data when they should not be
doing so. Now auditing connects for the schema
. Now auditing connects for the schema account is not a problem,
but
determining which are suspicious and which are due to the damned PeopleSoft
panel processor I can't see a way around easily from sys.aud$. Anyone else
been
there, done that??
Dick Goulet
--
Please see the official ORACLE-L FAQ
. The reason is that there have been
some
unexplained changes to data that have occurred over the last month that is
causing a pile of concern. It is believed that someone who has the schema
password is using SQL*Plus or Toad to update the data when they should not
be
doing so. Now auditing connects
not be
doing so. Now auditing connects for the schema account is not a
problem, but
determining which are suspicious and which are due to the damned
PeopleSoft
panel processor I can't see a way around easily from sys.aud$.
Anyone else been
there, done that??
Dick Goulet
--
Please see
the last month that is
causing a pile of concern. It is believed that someone who has the schema
password is using SQL*Plus or Toad to update the data when they should not
be
doing so. Now auditing connects for the schema account is not a problem,
but
determining which are suspicious and which are due
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Auditing logons
Folks,
Before I go off re-inventing the wheel once again I'll ask the group
is
anyone has tried this before. What I have is a request from damanagement
to
tell them
or Toad to update the data when they should not
be
doing so. Now auditing connects for the schema account is not a problem,
but
determining which are suspicious and which are due to the damned PeopleSoft
panel processor I can't see a way around easily from sys.aud$. Anyone else
been
there, done
they should not
be
doing so. Now auditing connects for the schema account is not a problem,
but
determining which are suspicious and which are due to the damned PeopleSoft
panel processor I can't see a way around easily from sys.aud$. Anyone else
been
there, done that??
Dick Goulet
--
Please see
SQL*Plus or Toad to update the data when they should not
be
doing so. Now auditing connects for the schema account is not a problem,
but
determining which are suspicious and which are due to the damned PeopleSoft
panel processor I can't see a way around easily from sys.aud$. Anyone else
been
unexplained changes to data that have occurred over the last month that is
causing a pile of concern. It is believed that someone who has the schema
password is using SQL*Plus or Toad to update the data when they should not
be
doing so. Now auditing connects for the schema account is not a problem
according to the docs its in there.
Sys Accountability: Heightened user accountability and database
security are now possible with the capability to audit all operations done by
user SYS(including all as SYSDBA and SUSOPER connections).
This is from the 9ir2 new features guide.
Haven't
Greetings,
I have a request from my boss to come up with a list of users for a
particular database. Since this is 805 database logon trigger is not an
option. Turning on audit trail will be an overkill and not sure if
performance will be acceptable if we do that. Other than querying v$session
Dennis,
How about using the listner.log file and gathering information on the
USER and HOST columns. That will tell you the login id and the name/ip
of the machine they logged in from.
ROR mª¿ªm
[EMAIL PROTECTED] 04/05/02 02:25PM
Greetings,
I have a request from my boss to come up with a list
that auditing will be an overkill? You do not have to
record everything. You can have as little as storing a row into SYS.AUD$
each time somebody connects. Bearable.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
Dennis,
You said that DBA_USERS has obsolete and duplicate entries. If you
gracefully warn the users and age the passwords then you can disable all
of the users that do not change the password and also get an accurate
list of users for a short period of time. It will also help clean up the
I agree with Stephane, auditing shouldn't be a problem. Be certain to
move SYS.AUD$ out of SYSTEM first:
alter table sys.aud$ move tablespace tools
storage (initial 128K next 128K);
alter index sys.i_aud1 rebuild tablespace tools
storage (initial 128K next 128K
everybody, is there a better way to do
this?
DBA_USERS view is not going to work because there are too many duplicate
and obsolete entries.
TIA
Dennis Meng
Database Administrator
Focal Communications Corp.
Why do you say that auditing will be an overkill? You do not have to
record everything
All,
I would like to audit all the database users upon
logon failure.
I know that someone must have been implemented similar
kind of auditing. Could you please share your
information with me.
At the same time I did create new profile and assign
it to all the database users. This new profile
the
dba_audit_trail view.
John
[EMAIL PROTECTED] wrote:
All,
I would like to audit all the database users upon
logon failure.
I know that someone must have been implemented similar
kind of auditing. Could you please share your
information with me.
At the same time I did create new profile
On Sunday 03 February 2002 15:30, Craig Munday wrote:
The thread on auditing tables and the mention of temporal or time-oriented
databases prompted me to ask about a design problem that has recurred on
different projects for me. Seeing as this problem has occurred multiple
times I figured that other
Title: Temporal or Time-Oriented Databases (was auditing tables)
The thread on auditing tables and the mention of temporal or time-oriented databases prompted me to ask about a design problem that has recurred on different projects for me. Seeing as this problem has occurred multiple times I
+ 1 for that sequence number,
and reinsert the row into the same table. So auditing was easy.
Prakash
-Original Message-
Sent: Tuesday, January 29, 2002 3:11 PM
To: Multiple recipients of list ORACLE-L
Now you're getting into the realm of Temporal or Time-
Oriented Databases.
Suppose
Foelz.Frank wrote:
TNX for your answers.
What I need is exactly what Oracle doesn't support. Logging who changed
what in a
special area of our database.
I think triggering the events will be much more specific and more easy to
change.
In case all our applications use the same
triggers -- that do an insert into an auditing table. Been there, done
that:
Insert -- add a row to the auditing table of all the new values with
one extra column type =I
Delete add a row to the auditing table with all the old values and
type=D
Update -- add two rows to the auditing table
On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote:
Update -- add two rows to the auditing table -- first with old values
and type = O
second with all the new values and type =N
Rachel,
I don't think you need two rows for updates. The old values
will be in the audit table, the new
Jared,
I just put the old values in the audit table with an additional column which
tells exactly which columns are changed. Ah the wonders of dynamic sql ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN
recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 29, 2002 10:05 AM
On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote:
Update -- add two rows to the auditing table -- first with old values
and type = O
second with all the new values and type =N
Rachel,
I
in a repository, too.
PB
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
triggers -- that do an insert into an auditing table. Been there,
done
that:
Insert -- add a row to the auditing table of all the new values with
one extra column type =I
Delete add a row to the auditing table with all
ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: AW: auditing tables
Is there some other reason for saving both in the audit table?
Jared,
You must be right.
But, if for some 'crazy' reason primary key of the record gets modified,
then you need both old and new in audit table
to the auditing table -- first with old
values and type = O
second with all the new values and type =N
--- Foelz.Frank [EMAIL PROTECTED] wrote:
What I need is exactly what Oracle doesn't support. Logging who
changed what in a special area of our database.
I think triggering
is always in the production table.
If a row is deleted, the whole thing goes in the audit table.
My purpose for these has been for occasional auditing.
I use code ( Perl, or course ) to generate the proper DDL
and triggers for all tables I wish to audit, placing them in
their own tablespaces.
Your
there -- time tracked
if you want
--- Jared Still [EMAIL PROTECTED] wrote:
On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote:
Update -- add two rows to the auditing table -- first with old
values
and type = O
second with all the new values and type =N
Rachel,
I don't think
process?
--- Jared Still [EMAIL PROTECTED] wrote:
On Tuesday 29 January 2002 03:00, Rachel Carmichael wrote:
Update -- add two rows to the auditing table -- first with old
values
and type = O
second with all the new values and type =N
Rachel,
I don't think you need two rows for updates
Hi all,
does anyone have experience in using Oracle's possibilities of auditing
a database ??
I am interested in performance questions i.e. is it a hughe loss of
performance
when auditing tables Inserts/Updates/Deletes. Should I use triggers instead
?
any hints (comments, websites, etc
Title: RE: auditing tables
Auditing is a definite overhead but the degree varies depending on what auditing is set up and how many transactions you have.
Auditing can tell you who did what to a table (IUD etc). What it will not do is store before and after values.
If that is what you want
] wrote:
Hi all,
does anyone have experience in using Oracle's possibilities of
auditing
a database ??
I am interested in performance questions i.e. is it a hughe loss of
performance
when auditing tables Inserts/Updates/Deletes. Should I use triggers
instead
?
any hints (comments
are better off with triggers and possibly an audit
table. Oracle doesn't record WHAT has been changed, just that the
table was accessed. So you don't know the row etc...
--- Foelz.Frank [EMAIL PROTECTED] wrote:
Hi all,
does anyone have experience in using Oracle's possibilities of
auditing
]
Sent: Friday, October 19, 2001 8:38 PM
Does anyone have any recommendations on auditing data changes on several
tables? I want to keep before and after data along with
username/timestamp.
I'm thinking of a DML trigger on each table and each with its own audit
table? Or what about
Does anyone have any recommendations on auditing data changes on several
tables? I want to keep before and after data along with username/timestamp.
I'm thinking of a DML trigger on each table and each with its own audit
table? Or what about a single audit table (using TO_CHAR to convert
On Mon, 13 Aug 2001, [EMAIL PROTECTED] wrote:
Who is the vendor for EZSQL? Do you have a web site for them?
www.google.com, type in ezsql and the first thing you get is
http://www.ezsql.net/
--
Galen Boyer
It seems to me, I remember every single thing I know.
--
Please see the official
:
Sent by: Subject: RE: auditing ... getting
offending SQL ??
[EMAIL PROTECTED
Guys,
One of our clients
wants us to audit connections to the DB. Apart from the obvious things is there
a way within auditing to view how they actually connected.
ie. from v$session
we can see whether it was via sqlplus, TOAD etc. etc.
I can't find out in
the docs whether this can
Lee,
what version of the database? I'm thinking a logon trigger here, to capture
and write the session info to a table
Rachel
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Oracle Auditing
Date
For the list, because we have already discussed it... nope, it's an 8i
feature
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle Auditing
Date: Wed, 11 Jul 2001 07:11:43 -0800
Rachel
Auditing
Date: Wed, 11 Jul 2001 04:45:54 -0800
Guys,
One of our clients wants us to audit connections to the DB. Apart from the
obvious things is there a way within auditing to view how they actually
connected.
ie. from v$session we can see whether it was via sqlplus, TOAD etc. etc.
I can't find
As you might have gathered from my previous e-mail I'm not a big fan of
functional division as opposed to project division.
Since I was moved to a different building from the developers much of the
time I don't spend dealing with the new paperwork and bureaucracy I spend on
the phone. I can see
Jay GC,
I guess I must live in heaven. Over here things are staying relatively the
same as they always have. Developers develop stuff (applications, data
warehouses, etc...) and in the process do some logical database design which the
DBA's (me included here) get to review all of it,
PROTECTED]
com cc:
Sent by: Subject: Re: Griping about
auditing (not the Oracle Kind)
root@fatcity.
com
06/25/2001
06:40 PM
Okay, my situation doesn't seem so bad now. Thanks!
The rules are mitigated by a number of sensible managers here and there who
do their best to see that things hold together.
And I won't comment in a public forum as to whether something necessary has
occasionally been done while paperwork is
On June 28, 2001 11:51 am, Miller, Jay wrote:
Yep, I've dealt with incredibly incompetent consultants (Because of
our new division of responsibilties, all programming must come from
the development team. I
This brings up an interesting point - I've noticed that recently
division of
That's actually a good idea. We can control the world by taking over
all the data. We will be so powerful. :)
[EMAIL PROTECTED] 06/25/01 11:45AM
A non-DBA? Is that because we stick together like the Mafia or
something?!
g
-Original Message-
Sent: Monday, June 25, 2001 3:32 PM
To:
Excuse me but you are a little presumptious and rude with that last mail. If
a process is put in place that requires a form to be signed and
authorisation to be given before action can be taken then I would be going
totally against the grain and would get into trouble for not adhering to the
Title: RE: Griping about auditing (not the Oracle Kind)
My
point precisely. I'm not putting my neck on the line because someone won't allow
me to do my job. Let them be the one who takes the hit when the s**t hits the
fan.
Thanks
Chris, good point well made (better than my knee jerk
Lee,
In my case (please see my previous post on the subject) I had proposed a
change that was rejected. In short I wanted to move a datafile during a
maintenance down day from one drive to another where there would be more room
for expansion. OK, so management rejected the change for dumb
Kline
ThinkSpark
Richmond, VA
804-744-1545
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Don
Granaman
Sent: Tuesday, June 26, 2001 1:20 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Griping about auditing (not the Oracle Kind)
I
Different situations . different solutions. Its all subjective. What
will work at one location is like using a feather to stop an elephant at
another. rather useless.
-Original Message-
Sent: Monday, June 25, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
Sorry but
Full authority and no responcibility - looks like very much an HMO. I don't
think I would survive in this environment for so long. Maybe if I did not
have where to go and had small children to feed. This is exactly what I
posted. This is no win game and possible only if payd by the hour and payd
rama@toyota.To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
com cc:
Sent by: Subject: Re: Griping about auditing
Kimberly;
Absolutely.
And I did not take ANY of your comments as Rude or Presumptuous. I am sorry
my comments in my note drove someone to think that of you.
-Original Message-
Sent: Tuesday, June 26, 2001 11:22 AM
To: Multiple recipients of list ORACLE-L
This is the line I
rama@toyota.To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
com cc:
Sent by: Subject: Re: Griping about
auditing (not the Oracle Kind)
root@fatcity
recipients of list
ORACLE-L [EMAIL PROTECTED]
house.com cc: (bcc: Jack van
Zanen/nlzanen1/External/MEY/NL)
Sent by: Subject: Griping about auditing (not
the Oracle Kind
Close, it's a brokerage.
But regarding flooding the SVP, one of my favorite Dilbert moments came
about a month after the new procedures were in place. They were getting
forms from multiple sources (me, the developers on our OLTP database and the
developers from our datawarehouse). All those
A non-DBA? Is that because we stick together like the Mafia or
something?!
g
-Original Message-
Sent: Monday, June 25, 2001 3:32 PM
To: Multiple recipients of list ORACLE-L
We've been through an internal audit and I was just wondering if anyone
else
has to deal with the rather
Jay;
I have had to go thru the same thing a couple times on a previous job with
Auditors. Every time those kind of restrictions were placed on us it
brought things to a snails pace or, in some conditions, a complete halt.
Sooner or later they realized that it was unreasonable and lifted them.
Alex,
that was the result of an inexperienced DBA. an experienced DBA would
know that there is a load placed on the server during datafile addition
time. if you have a server with extra oomf, then the users should not see
any difference.
it sounds like you had a very sensitive database that
Wahey !!! The answer I was going to provide. We started calling the manager
up quite frequently at home to authorise changes - he eventually saw sense.
Not quite as bad as 2am in the morning but inconvenient enough for him to
put a stop to it.
Best of Luck.
-Original Message-
Sent: 25
1 - 100 of 133 matches
Mail list logo