Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Privileges for truncate table

RE: Privileges for truncate table

From: Troiano, Paul (CAP, GEFA) <Paul.Troiano_at_gecapital.com>
Date: Fri, 9 Jun 2000 19:00:50 -0400
Message-Id: <10523.108491@fatcity.com>


The required privilege is DROP ANY TABLE as of version 7.1. Prior to that DELETE ANY TABLE would have worked (It was considered a bug). Remember that truncating is a DDL operation, not DML..

I believe you could use the DBMS_SQL package to create a truncate procedure for the particular user. Create the procedure in the table owner's schema and then grant execute permissions to the user that requires it (or better yet, use a role).

		-----Original Message-----
		From:	Rishi Jain-R-2 [mailto:jain.r.2_at_pg.com]
		Sent:	Friday, June 09, 2000 1:50 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Privileges for truncate table


		Sandeep ,

		To Truncate table in other users schema you need to have
delete any table and
		not drop any table system privilege..


	

		 Internet Mail Message

		 Received from host: newsfeed.cts.com

		 [209.68.192.199]

	



		Envelope Sender:    root_at_fatcity.cts.com


		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)




		There is no suuch privilege truncate table. Delte table will
not help
		either. You need drop any table privilege

		Sandeep

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


		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


		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)




		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).
		--
		Author: Rishi Jain-R-2
		  INET: jain.r.2_at_pg.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).
		-- 
		Author: Rishi Jain-R-2
		  INET: jain.r.2_at_pg.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') Received on Fri Jun 09 2000 - 18:00:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US