Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Privilege to be abl to truncate another user's table
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
-- 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
![]() |
![]() |