Re: Make Oracle AR application read-only

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_at_x.washington.edu
(replace 'x' with 'u' to respond)