Return-path: Envelope-to: oracle-l@orafaq.net Delivery-date: Wed, 25 Sep 2002 01:12:41 +0800 Received: from newsfeed.cts.com ([209.68.248.164]) by jean.onefuse.com with esmtp (Exim 3.36 #1) id 17ttEn-0001dk-00 for oracle-l@orafaq.net; Wed, 25 Sep 2002 01:12:41 +0800 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA86528; Tue, 24 Sep 2002 10:12:27 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004D8029; Tue, 24 Sep 2002 09:58:51 -0800 Message-ID: Date: Tue, 24 Sep 2002 09:58:51 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Glenn Travis" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Glenn Travis" Subject: RE: Privileges needed for truncate Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable delete wasn't enough for me. had to grant 'drop any table'. >From the Oracle8i SQL Reference Release 3 (8.1.7) manal: "To truncate a table or cluster, the table or cluster must be in your = schema or you must have DROP ANY TABLE system privilege. " > -----Original Message----- > From: Ruth Gramolini [mailto:rgramolini@tax.state.vt.us] > Sent: Thursday, September 19, 2002 2:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Privileges needed for truncate >=20 >=20 > To truncate you need delete privileges. Ruth > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" > Sent: Thursday, September 19, 2002 10:23 AM >=20 >=20 > Hi >=20 >=20 > 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=20 > needed (DBA is a > bit OTT :-)) > Try them one by one does not sound appealing at all >=20 > TIA >=20 >=20 > Jack >=20 > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze=20 > informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming=20 > van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden=20 > e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet=20 > garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van=20 > onbevoegde derden. >=20 > Indien bovenstaand e-mailbericht niet aan u is gericht,=20 > verzoeken wij u > vriendelijk doch dringend het e-mailbericht te retourneren=20 > aan de verzender > en het origineel en eventuele kopie=EBn te verwijderen en te=20 > vernietigen. >=20 > Ernst & Young hanteert bij de uitoefening van haar=20 > werkzaamheden algemene > voorwaarden, waarin een beperking van aansprakelijkheid is=20 > opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > 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=20 > communication > without the authority of Ernst & Young. Ernst & Young is=20 > neither liable for > the proper and complete transmission of the information=20 > contained in this > communication nor for any delay in its receipt. Ernst & Young does not > guarantee that the integrity of this communication has been=20 > maintained nor > that the communication is free of viruses, interceptions or=20 > interference. >=20 > If you are not the intended recipient of this communication=20 > please return > the communication to the sender and delete and destroy all copies. >=20 > In carrying out its engagements, Ernst & Young applies=20 > general terms and > conditions, which contain a clause that limits its liability.=20 > A copy of > these terms and conditions is available on request free of charge. > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D >=20 >=20 >=20 >=20 >=20 > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jack van Zanen > INET: nlzanen1@EY.NL >=20 > 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@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). >=20 > --=20 > Please see the official ORACLE-L FAQ: http://www.orafaq.com > --=20 > Author: Ruth Gramolini > INET: rgramolini@tax.state.vt.us >=20 > 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@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). >=20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: Glenn.Travis@sas.com 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@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).