| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Privileges for truncate table
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 (likesubscribing).
-- 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 (likesubscribing).
-- 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
 |
 |