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 ?
åy«±ç
ê~'jS Ä,PÛiÿü0ÂÚ}ª¢`.¶+T
D)!ÀDÀ4DÕ!Q
Hp0§'(V
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 ?
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 Particular Table Created by a One Oracle User , Is it possible
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,