Pl search these forums for previous discussions on this topic - https://community.oracle.com/search.jspa?q=read+only&type=discussion&after=year&place=%2Fplaces%2F1237
You cannot make tablespaces read only - you will have to create new custom responsibilities with read only permissions
MOS Doc 363298.1
MOS Doc 434797.1
we will not be able to make tables as read only as in 10.2.0.3.0 db this feature is not available, correct me if im wrong.
Correct, Oracle EBS requires the tablespaces not to be in read only mode and this explains why you get the above error.
If you want the access to be read-only from the application please see:
Is It Possible To Have Read-Only Responsibility Access? (Doc ID 1066616.1)
How To Create a QUERY_ONLY FORM (Doc ID 400380.1)
I found the note id : How To Make All The Responsibilities Read Only For A User 363298.1
we need to define the below code in CUSTOM.pll
here i replaced IF FND_PROFILE.VALUE('USER_NAME') = with IF FND_PROFILE.VALUE('USER_NAME') not in(' user names that needs to be exclued')
then created a custom profile, compiled the CUSTOM.pll
Now its working fine thanks all for your inputs.
IF event_name = 'WHEN-NEW-FORM-INSTANCE' THEN
IF FND_PROFILE.VALUE('USER_NAME')='<USER_NAME>' THEN
formname := NAME_IN('system.current_form');
blockname := GET_FORM_PROPERY(formname, FIRST_BLOCK);
WHILE (blockname is not null) LOOP
IF (GET_BLOCK_PROPERTY(blockname, BASE_TABLE) is not NULL) THEN
SET_BLOCK_PROPERTY(blockname, INSERT_ALLOWED, PROPERTY_FALSE);
SET_BLOCK_PROPERTY(blockname, UPDATE_ALLOWED, PROPERTY_FALSE);
SET_BLOCK_PROPERTY(blockname, DELETE_ALLOWED, PROPERTY_FALSE);
blockname := GET_BLOCK_PROPERTY(blockname, NEXTBLOCK);