Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> truncate; drop any table priv

truncate; drop any table priv

From: <cosmin_ioan_at_msn.com>
Date: Wed, 29 Dec 1999 16:49:30 GMT
Message-ID: <84ddh3$ep$1@nnrp1.deja.com> 





hello all;



I want let users truncate **some** tables from a master-user/owner's
schema but NOT to be able to truncate just any table.  If these users
have "drop any table" priv. then they'll be able to truncate any
table.  Any way to circumvent that?



Thank you,



Cosmin




Sent via Deja.com http://www.deja.com/



Before you buy.
Received on Wed Dec 29 1999 - 10:49:30 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US