Antwort: How to convert schema to readonly schema.
- From: "Martin Klier" <Martin.Klier@xxxxxxxxxx>
- To: avadhanimys@xxxxxxxxx
- Date: Mon, 22 Jun 2009 17:13:21 +0200
Another suggestion, in addition to the "two schemas approach":
Duplicate the schema, grant select rights as described, and create synonyms
on the granted objects. This has the advantage, that you needn't change
your sourcecode with schema specification if you don't have it already
prepared this way. Mostly for packages etc. this business is annoying
afterwards.
Regards
--
Mit freundlichem Gruß
Martin Klier
Senior Oracle Database Administrator
------------------------------------------------------------------------------
Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.: +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier@xxxxxxxxxx
www.klug-is.de
------------------------------------------------------------------------------
Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg
|------------>
| Von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Avadhani mys <avadhanimys@xxxxxxxxx>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| An: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|oracle-l <oracle-l@xxxxxxxxxxxxx>
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Datum: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|22.06.2009 14:00
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Betreff: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|How to convert schema to readonly schema.
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Gesendet |
| von: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|oracle-l-bounce@xxxxxxxxxxxxx
|
>--------------------------------------------------------------------------------------------------------------------------------------------------|
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
--
http://www.freelists.org/webpage/oracle-l
Other related posts:
- » Antwort: How to convert schema to readonly schema. - Martin Klier