Xref: alice comp.databases.oracle.server:83073
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.gamma.ru!Gamma.RU!carrier.kiev.ua!news.lucky.net!not-for-mail
From: "Alex P. Zotov" <alex@soft-review.kiev.ua>
Newsgroups: comp.databases.oracle.server
Subject: Re: DDL
Date: Wed, 2 Feb 2000 18:17:23 +0200
Organization: unknown
Lines: 18
Sender: news-server@lucky.net
Distribution: world
Message-ID: <AA5Y5cuS808@soft-review.kiev.ua>
References: <874pmd$mke$1@pegasus.tiscalinet.it>
Reply-To: alex@soft-review.kiev.ua
Mime-Version: 1.0
Content-Type: text/plain;  charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: news.lucky.net 949509550 13903 193.193.193.102 (2 Feb 2000 16:39:10 GMT)
X-Complaints-To: usenet@news.lucky.net
NNTP-Posting-Date: 2 Feb 2000 16:39:10 GMT
X-Return-Path: alex@soft-review.kiev.ua

DerKommisar <baldain@kataweb.it> wrote in message
news:874pmd$mke$1@pegasus.tiscalinet.it...
> How Can I see if a User has done several statement DDL ?
> There are any tables or view about it?
>
> Obvious my database Doesn't in AUDIT

On 8.0 you can create ddl - trigger.
E.g:
create trigger tr_alter before alter on schema
begin
  null;
end;
--
Alex P. Zotov