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