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
>
> As far as I know, there is no specific privilege to grant for
> truncate.
> In other words, only the owner of the table can truncate the table.
> What you can do is create a stored procedure in the same schema as the
> table which has the statement to truncate the table and grant execute
> privilege on the procedure to others.
> Hope that helps.
>
> Hari Vattyam
> hvattyam_at_one.net
Received on Wed Feb 24 1999 - 07:33:31 CST
