You must grant the drop any table privilege.
Something I'm sure you do not want to do.
The other thing is to do a stored proc that do a
truncate table.
- Franck_Vasseur_at_ingerrand.com a icrit : >
>
> 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).
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Yahoo! Photos -- now, 100 FREE prints!
Received on Fri Jun 09 2000 - 08:42:42 CDT
