Delete table will not be enough. Test it.
TRUNCATE is DDL, and subsequently triggers updates to the system =
tables.
DELETE is DML, and does not update system tables.
The user must either have delete any table privilege, or you could =
create a
stored procedure owned by the owner of the table that does the truncate =
for
the user. Then you just need to grant execute on the stored procedure.
> -----Original Message-----
> From: Ashish Shah [SMTP:ar_shah_at_yahoo.com]
> Sent: Friday, June 09, 2000 11:03 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Privileges for truncate table
>=20
>=20
> You need delete table privilege to truncate=20
> table..
>=20
>=20
> --- paquette stephane <stephane_paquette_at_yahoo.com>
> wrote:
> > You must grant the drop any table privilege.
> > Something I'm sure you do not want to do.
> >=20
> > The other thing is to do a stored proc that do a
> > truncate table.
> >=20
> >=20
> >=20
> > --- Franck_Vasseur_at_ingerrand.com a =E9crit : >=20
> > >=20
> > > Hi Gurus,
> > >=20
> > > which privilege(s) should I give a user to
> > authorize
> > > it to truncate a table
> > > belonging to another schema.
> > >=20
> > > e.g. how could TOTO truncate SCOTT.EMP ?
> > >=20
> > > TIA
> > >=20
> > > Franck
> > >=20
> > >=20
> > > --=20
> > > Author:=20
> > > INET: Franck_Vasseur_at_ingerrand.com
> > >=20
> > > Fat City Network Services -- (858) 538-5051=20
> > 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).
> >=20
> >=20
> > =3D=3D=3D=3D=3D
> > Stephane Paquette
> > DBA Oracle
> > stephane_paquette_at_yahoo.com
> > spaquette_at_houra.fr
> > (33) 01 53 93 06 50
> >=20
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Photos -- now, 100 FREE prints!
> > http://photos.yahoo.com
> > --=20
> > Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
> > INET: stephane_paquette_at_yahoo.com
> >=20
> > 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).
>=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --=20
> Author: Ashish Shah
> INET: ar_shah_at_yahoo.com
>=20
> 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
Received on Fri Jun 09 2000 - 16:28:16 CDT
