Re: Truncate Command

From: PD Miller <news_watcher_at_caribdata.no_spam.demon.co.uk>
Date: Wed, 15 Apr 1998 15:10:36 GMT
Message-ID: <news_watcher-1504981614150001@caribdata.demon.co.uk>

In article <ErGHD7.An4_at_unx.sas.com>, "Lui Yuan Tze" <ssplyt_at_pacific.net.sg> wrote:

> Hi,
> What privileges is reqd for an oracle user to Truncate a table belonging
> to another schema ?
> I tried to grant Delete Table to the oracle user but still get insufficient
> privileges .
>
> Cheers

Prerequisites
The table or cluster must be in your schema or you must have DELETE TABLE system privilege.
If you are using Trusted Oracle, your DBMS label must match the creation label of the table or cluster or you must satisfy one of these criteria. If the creation label of the table or cluster is not comparable or higher than your DBMS label, you must have READUP system privilege.

--
PD Miller
Carib Data Limited Received on Wed Apr 15 1998 - 10:10:36 CDT