It took me 20 minutes to write such a tool, it consists of a shell script, 4 tables, one trigger
and one huge udump directory.
We do everything that you described ...
Raj
--- Tracy Rahmlow <tracy.rahmlow_at_aexp.com> wrote:
> Currently, our IS support staff have full access to the production
> database. To minimize risk and to satisfy audit concerns, we need to
> address the issue. Preferably as automated as possible. Does a tool
> exist, whereby a support staff member could request update access on table
> abc for x hours and then have the request forwarded for approval and then
> implemented? The access would then be automatically revoked after the
> timeout period. Auditing would be invoked, blah, blah, blah.... Any
> thoughts??
>
> American Express made the following
> annotations on 07/20/2004 03:03:52 PM
> ------------------------------------------------------------------------------
> ******************************************************************************
>
> "This message and any attachments are solely for the intended recipient and may contain
> confidential or privileged information. If you are not the intended recipient, any disclosure,
> copying, use, or distribution of the information included in this message and any attachments is
> prohibited. If you have received this communication in error, please notify us by reply e-mail
> and immediately and permanently delete this message and any attachments. Thank you."
>
> ******************************************************************************
>
>
> ==============================================================================
>
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>
Best Regards
Raj
select mandatory_disclaimer from company_requirements;
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Jul 21 2004 - 07:35:44 CDT
