Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Truncate Table Permissions
Yeah you have to grant the ability on any table.
But I have to allow users to do this and I create a procedure as sys that will truncate the table. It simply takes the tablename as input, checks the schema to see if that table exist and then it truncates it as sys. I then grant execute on this proc to the user.
If you want a copy.. send me a note a dsivick_at_carolinas.org and I will send you the code.
David
I create a procedure as sys the will truncate a table in a certain schema
Eric Hanson <ehanson_at_gr.com> wrote in message
news:36D58531.25B61292_at_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 Fri Feb 26 1999 - 15:38:36 CST