| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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
John,
Sounds like a nice implementation. If you have the=20 code handy, I'd be interested.
-Mark
-----Original Message-----
From: John Flack [mailto:JohnF_at_smdi.com]
Sent: Friday, February 13, 2004 5:31 PM
To: oracle-l_at_freelists.org
Subject: RE: Privilege to be abl to truncate another user's table
Yes, you could grant "drop any table" and it would work, but I hate to =
=3D
grant that much power to do this. So, I create a truncate procedure in =
=3D
a COMMON schema that has the drop any table privilege. It does the =3D
truncate with an EXECUTE IMMEDIATE, only if the user has the DELETE =3D
privilege on the table. If you're interested, I'll go find the code for =
=3D
the procedure.
-----Original Message-----
From: Viktor [mailto:stant_98_at_yahoo.com]
Sent: Friday, February 13, 2004 3:58 PM
To: oracle-l_at_freelists.org
Subject: Privilege to be abl to truncate another user's table
Hello,
=3D20
Can someone help me figure out how user A can truncate table in user b =
=3D
schema?
Isnt this drop any table priv? Oracle 8.1.7
=3D20
Thanks
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 16:58:21 CST
 |
 |