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
L PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, January 30, 2002 8:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Truncate Table Privilige ?
>
> no
>
>
> --- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote:
> > For a Par
no
--- VIVEK_SHARMA <[EMAIL PROTECTED]> wrote:
> For a Particular Table Created by a One Oracle User , Is it possible
> to
> TRUNCATE the SAME Table by ANOTHER Oracle user by Giving Some
> Suitable
> Priviliges Other than DBA & DROP ANY TABLE Priviliges ?
>
>
_
