Re: Truncate problem

Steve Main wrote:

Actually the situation is :

1. Truncate is indeed a DDL
2. Imagine you use owner2 to DROP table synstores, what will happen ? Same apply to Truncate table synstores, isn't it ?

Michael

> I have run into a problem that is probably documented somewhere but I can't
> find it.
>
> I create a table "stores" as owner1
> I create a public synonym "synstores" for table stores.
>
> I then grant a role to owner2 that has, among others "delete any table" as
> one of it's permissions.
>
> the problem is owner2 can "see" the stores table but can't truncate the
> table without qualifying it.
>
> ex: as owner2
>
> desc synstores; OK
>
> truncate table synstores; Fails with table or view does not exist
>
> truncate table owner1.stores OK
>
> Does anyone know why this works this way ? Am I setting this up wrong ?
Received on Wed Apr 09 1997 - 00:00:00 CDT