Re: Lock Table

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 8 Sep 2005 09:10:17 -0400
Message-ID: <ZfOdnRkY8Kenpb3eRVn-oA@comcast.com>

"Iain William Wiseman" <bibble_at_paradise.net.nz> wrote in message news:431fe951$1_at_clear.net.nz...
> Is there a way to lock table for select.
>
> I.E. Something a bit stronger than
>
> LOCK TABLE MY_TABLE IN EXCLUSIVE MODE;
>
> Tried this and on a separate sqlplus session I could do
>
> select (1) from my_table;
>
> As per documentation I might add. However I would like it not to be
> possible to do this.
>
> Thanks,
> Iain

this is done via privileges, or perhaps via VPD policies if the table unavailability is a recurring requirement

what exactly are you trying to do? could you provide a more detailed explanation of the process, and also provide your DB version?

++ mcs Received on Thu Sep 08 2005 - 08:10:17 CDT