RE: Truncate Privilege

Just in case this wasn't clear you create the pl/sql procedure as the owner of the table you want truncated and then you grant execute on the procedure to the user who will be doing the truncating.

Thanks,
Jay Miller
Sr. Oracle DBA
x68355  

-----Original Message-----

From: Fuad Arshad [mailto:fuadar_at_yahoo.com] Sent: Monday, April 25, 2005 11:54 AM
To: BurtonL_at_frmaint.com; oracle-l_at_freelists.org Subject: Re: Truncate Privilege

you probably have to give drop any table privilege sine oracle does not have a truncate table priv(truncate is a ddl). but if you want to be secure.
create pl/sql procedute that userscan use to truncate specific tables. "Burton, Laura" <BurtonL_at_frmaint.com> wrote: Can someone tell me what privilege is needed for a user to truncate a table that is not owned by that user?

I have looked at Metalink and it states the Drop Any Table privilege, but this doesn't work either. The user can select, insert, and even delete from the table. =20

Thank you, Laura

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Apr 28 2005 - 11:54:43 CDT