| 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
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
From: Sandeep Dubey <sandeep.dubey_at_induscorp.com> on 06/09/2000 02:14 PM
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
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
-----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-LReceived on Fri Jun 09 2000 - 13:30:38 CDT
(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
 |
 |