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

    Read only Apps in EBS

    951027

      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 10.2.0.3.0 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 10.2.0.3.0  db this feature is not available, correct me if im wrong.

       

      please give your variable advises thanks all

       

       

      our db version is 10.2.0.3.0

      application : 11.5.10.2

      os : linux