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 -> Re: using truncate in oracle7 procedures

Re: using truncate in oracle7 procedures

From: Russ Eberle <russ.eberle_at_born.com>
Date: 1996/12/24
Message-ID: <59pe6h$leg@news.mr.net>#1/1 







Just remember, the procedure will run with the permissions of the user
that created it.  If you REALLY want everyone who has execute
permission on a dynamic DDL procedure to be able to say... DROP TABLE,
then this works well.  On the other hand, perhaps a truncate procedure
would work better, maybe even use some kind of config table that has
the tables where truncation is allowed etc.



Just rambling...



Russ			russ.eberle_at_born.com
Received on Tue Dec 24 1996 - 00:00:00 CST












Original text of this message













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