Re: Truncate Table Privilige ?

Not directly, but you may have the owner of  the table create a stored procedure that performs a truncate and then grant execute on that procedure to whoever he wants to run this procedure.  by default a stored procedure runs under the privilege of the compiler of the procedure.

Hope this helps,
John

wisernet100_at_yahoo.com wrote:

  no--- VIVEK_SHARMA <VIVEK_SHARMA_at_infy.com> wrote:   

    For a Particular Table Created by a One Oracle User , Is it possibletoTRUNCATE the SAME Table by ANOTHER Oracle user by Giving SomeSuitablePriviliges Other than DBA & DROP ANY TABLE Priviliges ?     

    __________________________________________________Do You Yahoo!?Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com