Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Permission to TRUNCATE table

Permission to TRUNCATE table

From: Elmo <DoNoSpam_at_NoSpam.org>
Date: Tue, 21 Oct 2003 16:36:58 -0400
Message-ID: <bn45d8$19s6$1@f04n12.cac.psu.edu> 





I have set up a ROLE and assigned permissions to INSERT, SELECT, 
DELETE, and UPDATE tables to that ROLE.



I have a user with that ROLE.



The user cannot TRUNCATE TABLE_NAME but can DELETE FROM TABLE_NAME.



What permission/rights needs to be granted in order to TRUNCATE the 
table?



Anyone with a clue?  I'm fresh out.
Received on Tue Oct 21 2003 - 15:36:58 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US