Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: truncate table command
I believe you must also grant DROP ANY TABLE as well. I had this problem and I added the DROP grant. You also have to specify the owner of the table when doing the actual truncate, i.e., if you are calling a.SQL script, you have to call it with a parameter. Thus, inside of the .SQL script you will have
TRUNCATE TABLE &1.NAMEOFTABLE I have table owners like "NAME_DB". If you also have an underscore in your owner name, you would do the following:
TRUNCAT TABLE &1._DB.NAMEOFTABLE. Hope this helps.
Jackie Peale
Philippe Mendes <EURO.FINANCE_at_wanadoo.fr> wrote in article
<341FE624.E63FD5BE_at_wanadoo.fr>...
> What is the way to permit to an none dba user to do a 'truncate table'
> on a table of an other user ?
> Which privileges must i give to the user.
> I have try to do an 'grant delete any table' but it has done no change.
>
> thanks for helping me.
>
>
Received on Wed Sep 17 1997 - 00:00:00 CDT