Ashish,=20
Delete table privilege WON'T truncate tables. It will just delete =
rows
from the table. Truncating a table and Deleting rows from a table are 2
different things. =20
=20
One needs to have 'drop' table privilege..=20
Ignore what the Oracle Doc said. Just try it yourself... =20
=20
- Kirti =20
> -----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
Received on Fri Jun 09 2000 - 14:07:59 CDT
