Home » RDBMS Server » Server Administration » Block updates
Block updates [message #133743] Mon, 22 August 2005 01:17 Go to next message
srraajesh
Messages: 63
Registered: May 2005
Member
Hi Gurus

Is there any way to prevent updates on a set of rows alone in a table in Oracle..

Please clarify...

srr..

Report message to a moderator

Re: Block updates [message #133771 is a reply to message #133743] Mon, 22 August 2005 03:42 Go to previous messageGo to next message
Frank Naude
Messages: 4589
Registered: April 1998
Senior Member
Yes, you can lock rows. If locking isn't sufficient, you need to design your own solution (maybe you can add a field to the table to indicate if the row is "locked" or not).

Why are you asking?

Best regards.

Frank

Report message to a moderator

Re: Block updates [message #133775 is a reply to message #133771] Mon, 22 August 2005 03:47 Go to previous messageGo to next message
srraajesh
Messages: 63
Registered: May 2005
Member
I have a setup where I dont want users to update some rows of the table. Can you tell me how to lock specific rows in a table?

Srr

Report message to a moderator

Re: Block updates [message #133778 is a reply to message #133775] Mon, 22 August 2005 03:50 Go to previous messageGo to next message
Frank Naude
Messages: 4589
Registered: April 1998
Senior Member
Lookup the "SELECT ... FOR UPDATE ...;" statement in the SQL Reference Guide.

Best regards.

Frank

Report message to a moderator

Re: Block updates [message #133866 is a reply to message #133743] Mon, 22 August 2005 08:21 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
I believe you can also use things like FGAC, and row level security.

Report message to a moderator

Previous Topic: Tablespace problem
Next Topic: Dropping User takes 1 hour
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 04 00:11:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.