RE: Privileges for truncate table

From: Rishi Jain-R-2 <jain.r.2_at_pg.com>
Date: Fri, 9 Jun 2000 10:45:59 -0400
Message-Id: <10523.108404@fatcity.com>

I think its delete any table..

                                                                
 Internet Mail Message                                          
 Received from host: newsfeed.cts.com                           
 [209.68.192.199]

Envelope Sender: root_at_fatcity.cts.com

From: Sandeep Dubey <sandeep.dubey_at_induscorp.com> on 06/09/2000 11:11 AM

Please respond to oracle-l_at_fatcity.com

To: Multiple recipients of list ORACLE-L <oracle-l_at_fatcity.com> cc: (bcc: Rishi Jain-R-2/PGI)
Subject: RE: Privileges for truncate table

Frank,

You need to grant drop any table system privilege.

Sandeep

-----Original Message-----
Sent: Friday, June 09, 2000 10:12 AM
To: Multiple recipients of list ORACLE-L

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).
--
Author: Sandeep Dubey
  INET: sandeep.dubey_at_induscorp.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).

Received on Fri Jun 09 2000 - 09:45:59 CDT