7 Replies Latest reply: Aug 13, 2014 5:11 AM by 951027 RSS

    Read only Apps in EBS


      HI all,


      We want to release application access to user's as  read only. In case if they want to modify any record then it shouldn't allow.

      one of the option i found was to make tablespace readonly. we tried this on custom tablespace and it was working.

      however if we make tablespace APPS_TS_TX_DATA (OATM Performed on db)  then application users are not able to submit any new concurrent request we are getting the below error

      ora-01110 data file 523: '/u01/oracle/test.....


      we will not be able to make tables as read only as in  db this feature is not available, correct me if im wrong.


      please give your variable advises thanks all



      our db version is

      application :

      os : linux