469,623 Members | 1,273 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Lock table only allow INSERT

Hi,
recently, i was assigned as a new dba for our system. I found that my
statistic keep change from time to table. To look for the cause, i
wanna to lock a table, means only allow user to insert. Others than
that, noway.

Can i use the Lock table command? or others comand?

p/s: we are using 9i client and 6i developer
regards,
Lee Cho
Jul 19 '05 #1
1 4360
not sure if your plan is the best approach -- you might not last too long as
a new dba if you prevent users from selecting or updating data they just
entered

however, if you feel there's a legitimate case for making a table
'insert-only' (kind of like one of those black hole neutron star thingies)
you would have to do it via table privileges, not via the lock statement

i would suggest that you elaborate on the problem that you are trying to
solve so that posters can suggest alternative approaches to accomplishing
your goals

--
Mark C. Stock
mcstock -> enquery(dot)com
www.enquery.com training & consulting
<le****@unitem.edu.my> wrote in message
news:ad*************************@posting.google.co m...

| Hi,
| recently, i was assigned as a new dba for our system. I found that my
| statistic keep change from time to table. To look for the cause, i
| wanna to lock a table, means only allow user to insert. Others than
| that, noway.
|
| Can i use the Lock table command? or others comand?
|
| p/s: we are using 9i client and 6i developer
| regards,
| Lee Cho
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Bruce Pullen | last post: by
9 posts views Thread by kavallin | last post: by
18 posts views Thread by dunleav1 | last post: by
1 post views Thread by leecho | last post: by
6 posts views Thread by michael.spoden | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.