Re: Privileges for truncate table

You need delete table privilege to truncate table..

• paquette stephane <stephane_paquette_at_yahoo.com> wrote:
  > You must grant the drop any table privilege.
  > Something I'm sure you do not want to do.
  >
  > The other thing is to do a stored proc that do a
  > truncate table.
  >
  >
  >
  > --- Franck_Vasseur_at_ingerrand.com a icrit : >
  > >
  > > Hi Gurus,
  > >
  > > which privilege(s) should I give a user to
  > authorize
  > > it to truncate a table
  > > belonging to another schema.
  > >
  > > e.g. how could TOTO truncate SCOTT.EMP ?
  > >
  > > TIA
  > >
  > > Franck
  > >
  > >
  > > --
  > > Author:
  > > INET: Franck_Vasseur_at_ingerrand.com
  > >
  > > Fat City Network Services -- (858) 538-5051
  > FAX:
  > > (858) 538-5051
  > > San Diego, California -- Public Internet
  > > access / Mailing Lists
  > >
  >

  ---

  
  > > 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).
  >
  >
  > =====
  > Stephane Paquette
  > DBA Oracle
  > stephane_paquette_at_yahoo.com
  > spaquette_at_houra.fr
  > (33) 01 53 93 06 50
  >
  > __________________________________________________
  > Do You Yahoo!?
  > Yahoo! Photos -- now, 100 FREE prints!
  > http://photos.yahoo.com
  > --
  > Author: =?iso-8859-1?q?paquette=20stephane?=
  > INET: stephane_paquette_at_yahoo.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > 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).
  

  ---