RE: Privileges needed for truncate

From: Bernard, Gilbert <Gilbert.Bernard_at_caissedesdepots.fr>
Date: Thu, 19 Sep 2002 07:28:31 -0800
Message-ID: <F001.004D3CAF.20020919072831@fatcity.com>

DROP ANY TABLE include the privilege TRUNCATE. But is not so secure. An ohher way is create a procedure to do the truncate base on user_table wich who is the owner of the tables.

	-----Message d'origine-----
	De:	Jack van Zanen [mailto:nlzanen1_at_EY.NL]
	Date:	jeudi 19 septembre 2002 16:24
	À:	Multiple recipients of list ORACLE-L
	Objet:	Privileges needed for truncate

	Hi


	I need to create a user/role that among other stuff must be able to
	truncate a table. I can't figure out which privileges are needed


(DBA is a

	bit OTT :-))
	Try them one by one does not sound appealing at all

	TIA


	Jack

	===================================================================
	De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
	uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
	vermenigvuldiging, verspreiding en/of verstrekking van deze
informatie aan
	derden is, behoudens voorafgaande schriftelijke toestemming van
Ernst &
	Young, niet toegestaan. Ernst & Young staat niet in voor de juiste
en
	volledige overbrenging van de inhoud van een verzonden
e-mailbericht, noch
	voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen
dat een
	verzonden e-mailbericht vrij is van virussen, noch dat
e-mailberichten
	worden overgebracht zonder inbreuk of tussenkomst van onbevoegde

derden.

        Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u

        vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender

        en het origineel en eventuele kopieën te verwijderen en te vernietigen.

        Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene

        voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De

        algemene voorwaarden worden u op verzoek kosteloos toegezonden.         

---

        The information contained in this communication is confidential and is

        intended solely for the use of the individual or entity to whom it is

        addressed. You should not copy, disclose or distribute this communication

        without the authority of Ernst & Young. Ernst & Young is neither liable for

        the proper and complete transmission of the information contained in this

        communication nor for any delay in its receipt. Ernst & Young does not

        guarantee that the integrity of this communication has been maintained nor

        that the communication is free of viruses, interceptions or interference.

        If you are not the intended recipient of this communication please return

        the communication to the sender and delete and destroy all copies.

        In carrying out its engagements, Ernst & Young applies general terms and

        conditions, which contain a clause that limits its liability. A copy of

	these terms and conditions is available on request free of charge.
	===================================================================





	-- 
	Please see the official ORACLE-L FAQ: http://www.orafaq.com
	-- 
	Author: Jack van Zanen
	  INET: nlzanen1_at_EY.NL

	Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
	San Diego, California        -- Mailing list and web hosting

services         

---

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bernard, Gilbert
  INET: Gilbert.Bernard_at_caissedesdepots.fr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Thu Sep 19 2002 - 10:28:31 CDT