|
Home > Archive > Oracle Server Tools > November 2004 > Make Oracle AR application read-only
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Make Oracle AR application read-only
|
|
|
| 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!
| |
| DA Morgan 2004-11-28, 5:48 pm |
| 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)
|
|
|
|
|