Re: Audit Help

From: Marco Koch <mkoch_at_privat.toplink.de>
Date: Wed, 06 Jan 1999 10:24:26 GMT
Message-ID: <36933404.2468599@news.freiburg.toplink.de>

You have to look at sys.aud$ table.
There are a number of views related to this table. The views are created through the CATAUDIT.SQL skript which is located in $ORACLE_HOME/RDBMS[version]/ADMIN directory You can get a list of the available views and their description with the following statement:
COLUMN table_name FORAMT a25
COLUMN comments FORMAT a45 WORD
SELECT
  table_name,
  comments
FROM
  dictionary
WHERE
  table_name LIKE '%_AUDIT%';

regards,
-Marco Koch

On Mon, 4 Jan 1999 11:43:52 -0500, "Jeff Reed" <jgreed_at_edgenet.net> wrote:

>Can someone tell me which table I need to look in to see what users have
>logged on to a database? I do have auditing turned on.
>
>TIA Jeff
>
>
Received on Wed Jan 06 1999 - 04:24:26 CST