Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Newbie Question

Re: PL/SQL Newbie Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 08 May 2005 22:18:46 +0200
Message-ID: <1uss7156bkskpo9vurg8ae0nrna66letcm@4ax.com>


On 8 May 2005 12:49:18 -0700, "Ed_Zep" <ed_zep_at_ntlworld.com> wrote:

>I was going to set up a table and have the PL/SQL procedure update it
>but I know nothing about PL/SQL and was wondering if anyone could tell
>me a way of doing this?

Look up the AUDIT facility in the Oracle Rdbms admin manual. Enable audit by setting dba_audit_trail to db and run AUDIT CONNECT. The info you require will now be stored in DBA_AUDIT_SESSION.

Evidently, this has nothing to do with PL/SQL

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun May 08 2005 - 15:18:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US