Re: Truncate Table Permissions

From: Eric Hanson <ehanson_at_gr.com>
Date: Thu, 25 Feb 1999 10:15:29 -0700
Message-ID: <36D58531.25B61292@gr.com>

As per the books, in order to truncate a table the table or cluster must be in your schema or you must have DROP ANY TABLE system privilege.

Eric Hanson, DBA

Rodgers, Tony (CEI-Atlanta) wrote:

> I believe you can grant the delete privilege to the user and they will
> be able to perform a truncate (or obviously a delete) for the specified
> table. At least they won't be able to drop the table.
>
> > -----Original Message-----
> > From: Hari Vattyam [SMTP:hvattyam_at_one.net]
> > Posted At: Wednesday, February 24, 1999 7:24 AM
> > Posted To: comp.databases.oracle.server
> > Conversation: Truncate Table Permissions
> > Subject: Re: Truncate Table Permissions
> >
> > Gary Perkins wrote:
> > >
> > > Howdy,
> > > I want to grant a user permission to truncate table(s) in another
> > schema
> > > but do not want them to be able to drop the table(s), is this
> > possible??
> > >
> > > Cheers
> > > Gary Perkins
> > > g_t_perkins_at_bigpond.com
>
Received on Thu Feb 25 1999 - 11:15:29 CST