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: Privilege to be abl to truncate another user's table

RE: Privilege to be abl to truncate another user's table

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 13 Feb 2004 15:00:39 -0800
Message-ID: <B5C5F99D765BB744B54FFDF35F602621033DAECF@irvmbxw02>


There's always the tried and true "write a procedure that does all = necessary verifications and give execute privilege on the procedure to = userA." e.g.
create procedure truncate_table (table_owner_in varchar2, table_name_in = varchar2)
...
begin

   if user !=3D 'USERA' or table_owner_in !=3D 'USERB'    then raise_application_error (-20010, 'Insufficient privileges') ...

Then the owner of the procedure will need DROP ANY TABLE

> > -----Original Message-----
> > From: Viktor [SMTP:stant_98_at_yahoo.com]
> > =20
> > Can someone help me figure out how user A can truncate=20
> table in user b schema?
> > Isnt this drop any table priv? Oracle 8.1.7



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Feb 13 2004 - 17:00:39 CST

Original text of this message

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