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

From: Viktor <stant_98_at_yahoo.com>
Date: Fri, 13 Feb 2004 17:36:52 -0800 (PST)
Message-ID: <20040214013652.20105.qmail@web13421.mail.yahoo.com>

Thanks to all for your help! Drop any table did the job!  

Another quick question. Would a non-dba user (identified externally) be able to do full db export/import with just export_full_database import_full_database roles? If not, what privileges must user A have to be able to export user B schema?  

Thanks again!
Jacques Kilchoer <Jacques.Kilchoer_at_quest.com> wrote: 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
-----------------------------------------------------------------

---------------------------------
Do you Yahoo!?
Yahoo! Finance: Get your refund fast by filing online

----------------------------------------------------------------
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 - 19:36:52 CST