| 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
Sorry, you are right.
I spoke without researching.
:-O
Akshay Jain
-----Original Message-----
From: Rishi Jain-R-2 [mailto:jain.r.2_at_pg.com]
Sent: Friday, June 09, 2000 12:02 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Privileges for truncate table
I think its delete any table..
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)
Frank,
You need to grant drop any table system privilege.
Sandeep
-----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 - 11:21:27 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: 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') 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
 |
 |