Re: Make table read-only

"MS" <qcom_at_attbi.com> wrote in message
news:a2b6d46b.0410191235.47ef882f_at_posting.google.com...
| In addition to the trigger to disable DML, disabling table lock does
| the trick.
|
| So, for the mentioned example:
|
| SQL> alter table t disable table lock;
|
| This prevents sqlldr direct load, as well as truncate, and DDL's on
| this table (including drop table).
|
|
| -Madhu S

interesting

i don't think i've seen mentioned that the table owner can have her account disabled or create session privilege revoked -- but that affects more than just the one table, although it might fit into a broader scenario

++ mcs Received on Tue Oct 19 2004 - 16:14:07 CDT