Re: Truncate with Delete Privilege--Can I

From: Kirill Richine <krichine_at_radss.com>
Date: Thu, 24 Jun 1999 17:17:57 GMT
Message-ID: <377266ac.269374039@news.cadvision.com>

On Tue, 22 Jun 1999 15:53:07 -0400, "Stephen Hirsch" <stephen.hirsch_at_pharma.novartis.com> wrote:

>Hi,
>
>I have 2 schemas, user A and user B. A has been granted DELETE privilege on
>B's tables. When logged in as B, I can truncate the B.xxxx; when logged in
>as A, I can delete B.xxxx; however, when logged in as A, I cannot truncate
>B.xxxx.
>
>Did I do something wrong, or is this just not possible?

Usually it is not possible because truncate is a DDL command and having delete privilege has nothing to do with it.

You can go around it by either granting special system privilege DROP ANY TABLE to B or by writing a pl/sql procedure (owned by A) that does truncate using dynamic sql and granting execute on it to B.

k. Received on Thu Jun 24 1999 - 12:17:57 CDT