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

From: John Flack <JohnF_at_smdi.com>
Date: Tue, 17 Feb 2004 11:16:40 -0500
Message-ID: <91AFBA9B76078B4E8340A383EADEF1DB7EE52B@syn2kex1.smdi.com>

Jared, your method requires a separate procedure for each schema if not = for each table. To be sure, it is more secure as you can have the owner = control precisely which tables may be truncated and grant DELETE without = neccessarily granting TRUNCATE. Still, I prefer to write generalized = utilities whenever possible.

-----Original Message-----

From: Jared Still [mailto:jkstill_at_cybcon.com] Sent: Sunday, February 15, 2004 5:18 PM
To: Oracle-L Freelists
Subject: RE: Privilege to be abl to truncate another user's table

Jacques,

You don't need to give anyone the 'drop any table' priv.

Just create the procedures in the same schema as the table, and be selective about who to grant execute to.

Jared

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 Tue Feb 17 2004 - 10:16:40 CST