Re: Privileges for truncate table

Thanks Lisa,

I agreed with him to give DELETE on schema.table_name, rather giving a dangerous privilege...

THKS
Franck

|--------+----------------------->

|        |          Lisa_Koivu_at_ge|
|        |          lco.com      |
|        |                       |
|        |          00-06-09     |
|        |          15:58        |
|        |                       |


|--------+----------------------->

  >----------------------------------------------------------------------------|
  |                                                                            |
  |       To:     ORACLE-L_at_fatcity.com                                         |
  |       cc:     Franck Vasseur/im/esa/ingerrand_at_ingerrand                    |
  |       Subject:     Re: Privileges for truncate table                       |
  >----------------------------------------------------------------------------|

Hi Franck,

The user must have drop any table privilege. VERY DANGEROUS

Franck_Vasseur_at_ingerrand.com on 06/09/2000 09:12:24 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Lisa Koivu/GELCO)

Subject: Privileges for truncate table

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).