Re: How to convert schema to readonly schema.
- From: Adam Musch <ahmusch@xxxxxxxxx>
- To: subodh_deshpande@xxxxxxxxx
- Date: Mon, 22 Jun 2009 10:17:15 -0500
To complete option 0:
1. Change default tablespace of user to the read-only tablespace.
2. Revoke UNLIMITED TABLESPACE and/or RESOURCE from user.
3. Set quota 0 for all tablespaces.
On Mon, Jun 22, 2009 at 7:09 AM, Subodh Deshpande <
subodh_deshpande@xxxxxxxxx> wrote:
> two ways I guess,
> 0) put the eniter schema in a read only table space
> 1.1) create another schema which will be the owner and for rest all give
> only select access, sys, system and the new schema owner passwords should be
> kept secret or
> 1.2) other than the present owner give everybody as select access, and sys,
> system and the orginal schema owner passwords should be kept secret
>
> thanks and take care..subodh
> ------------------------------
> *From:* Avadhani mys <avadhanimys@xxxxxxxxx>
> *To:* oracle-l <oracle-l@xxxxxxxxxxxxx>
> *Sent:* Monday, 22 June, 2009 17:27:34
> *Subject:* How to convert schema to readonly schema.
>
> Hi Gurus,
>
> I have a requirement to convert schema to readonly schema. The application
> users should have select privilege on the objects he owns and application
> team would like to use this schema for reference.
>
> Thanks in Advance
> Aavadhani
>
>
--
Adam Musch
ahmusch@xxxxxxxxx
Other related posts:
