ily_saravanan

 Profile Answers by ily_saravanan Questions by ily_saravanan

• Mar 25th, 2007

 

If you update or delete the records in the table, at the same time, no body can update or delete the same records which you updated or deleted because oracle lock the data which u updated or deleted.

sandeep katta

• Apr 20th, 2007

 

You can use view for this purpose because you can set view as read only.

krishnaindia2007

 Profile Answers by krishnaindia2007 

• May 3rd, 2008

 

If a transaction is updating data in a database, it gets an exclusive lock on that part of the database. No other transaction can read or change this data.

sippsin

 Profile Answers by sippsin 

• Jul 22nd, 2008

 

you can select the table for updation

for eg: select * from emp for update;

no you can do the update/insert anything you want...

any other user or session would be able to do any insert/update to the same table only after you release the table by commit or rollback.....

dinesh.smhdr

 Profile Answers by dinesh.smhdr 

• May 11th, 2011

 

alter table tablename read only;

Art11

 Profile Answers by Art11 

• Sep 27th, 2011

 

Specify READ ONLY to put the table in read-only mode. When the table is in READ ONLY mode, you cannot issue any DML statements that affect the table or any SELECT ... FOR UPDATE statements. You can issue DDL statements as long as they do not modify any table data. Operations on indexes associated with the table are allowed when the table is in READ ONLY mode.
Specify READ WRITE to return a read-only table to read/write mode.

Read only:
ALTER TABLE SALES READ ONLY;

Back to read/write:
ALTER TABLE SALES READ WRITE;

priya dharan raj

 Profile Answers by priya dharan raj 

• Nov 15th, 2011

 

just grant select previlage on that particular table

velan

• Sep 11th, 2012

 

There are couple of ways
1) If there are user other than owner accessing this table then you can "grant select on TABLE_NAME"
2) Otherwise you DBA can create a role which will have only the privillege to only create table and assign this role to the user then even the owner of the table cannot manipulate the table data.

Smruti R Das

• Sep 26th, 2012

 

GRANT SELECT ON table_name TO user_name

Aditya

• Feb 28th, 2018

 

Lock table < table name > in exclusive mode;