Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: grant truncate

Re: grant truncate

From: Ramamohan B N <ramamohan.bn_at_tatainfotech.com>
Date: Wed, 10 Jan 2001 17:02:16 +0530
Message-Id: <10737.126249@fatcity.com>


Hi,

Create a procedure in user A's schema to truncate the table and grant execution on this procedure to user B.

Regards,
Mohan

wolfgang.ludewig_at_systor.com wrote:
>
> Hello,
>
> I have two users ( a and b).
> a owns the tables and
> b want to truncate the tables from a.
>
> How can I grant the user b the rights for this ??
>
> Wolfgang Ludewig
Received on Wed Jan 10 2001 - 05:32:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US