Yes. Instead of using a procedure, create a function or a package that does the truncate. Grant execute on the function or package to the user doing the truncate.
Without creating a procedure, a function or a package: no.
> -----Original Message-----
> jaysingh1_at_optonline.net
>
> Is there a way to give truncate privilege on particular table
> to a particular user?
> (Without using procedure)
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jacques Kilchoer
INET: Jacques.Kilchoer_at_quest.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri Nov 14 2003 - 13:19:25 CST
