Re: Truncate problem

      The way I see it, truncate is a DDL statement and synonyms    just don't work here.

      Hope I have been useful.

-- 

                     Aram Meguerian
                     aram_at_unisys.com.br

-------------------------------------------------------------------
   "There's no such a thing as a free lunch in the Universe."
          Lazarus Long Notebook's, Lazarus Long
		from Time enough for love, by Robert A. Heinlein
-------------------------------------------------------------------
I don't work at Unisys, it is just my Internet Provider, 
so don't blame it for anything I have just said.
-------------------------------------------------------------------



Steve Main <smain_at_cnw.com> escreveu no artigo
<01bc3f98$4b33dc00$107281ce_at_dp007>...


> Hey gang,

> 

> 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 ?

> 

> 

> Thanks

> 

> Steve

> 

>