RE: Privileges for truncate table

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

I think its delete any table and not truncate any table..i don't think a privilege "truncate any table " exists..

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

Envelope Sender: root_at_fatcity.cts.com

From: "Jain, Akshay" <akshay.jain_at_cit.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

I believe that unfortunately the privilege required is "truncate any table". Since this is too expansive, it is not really a good thing to grant.

Akshay Jain

---

Newcourt-CIT
Tel. (416) 507-5385
mailto:Akshay.Jain_at_cit.com

---

-----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: Jain, Akshay
  INET: Akshay.Jain_at_cit.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:44:20 CDT