Hi There,

I am quite new to Oracle AR application as I am an Oracle DBA. We are
running Oralce AR. My question is:
Is there any way to make Oracle AR application working read-only? I
want the users using Oracle AR to be still able to work with it and
retrieve data, but block them from updating, inserting & deleting data
against the backend AR DB.
Since Oracle AR users don't have their own DB account in the database,
they connect to a common DB account (APPS? Is that right?). I am not
sure how to make this readonly request happen and which one below is
applicable:
1. Revoke all the writable privilege from the common DB account
Would this cause Oralce AR to behave improperly? Some packages,
procedures & functions may turn out to be invalid?
2. Make the related tablespaces read-only


Thanks in advance!

[ Post a follow-up to this message ]

SW wrote:

> Hi There,
>
> I am quite new to Oracle AR application as I am an Oracle DBA. We are
> running Oralce AR. My question is:
> Is there any way to make Oracle AR application working read-only? I
> want the users using Oracle AR to be still able to work with it and
> retrieve data, but block them from updating, inserting & deleting data
> against the backend AR DB.
> Since Oracle AR users don't have their own DB account in the database,
> they connect to a common DB account (APPS? Is that right?). I am not
> sure how to make this readonly request happen and which one below is
> applicable:
> 1. Revoke all the writable privilege from the common DB account
> Would this cause Oralce AR to behave improperly? Some packages,
> procedures & functions may turn out to be invalid?
> 2. Make the related tablespaces read-only
>
>
> Thanks in advance!

Alter the tablespaces to READONLY.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

[ Post a follow-up to this message ]