Re: How to achieve in granting privilege - on one schema to other and vice versa
- From: Ravi Madabhushanam <ravi.madabhushanam@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 16 Jun 2010 09:55:58 +0530
We can only grant privileges either at object level or at the system level.
We cannot grant privileges at schema level in any direct way. Alternatively,
you can identify individual objects of each schema and grant privileges on
all the objects to achieve this.
However create,alter and drop privileges cannot be granted this way.
~Ravi.M
On Wed, Jun 16, 2010 at 7:44 AM, Apps DBA <dbaorapps@xxxxxxxxx> wrote:
> Hello gurus,
>
> How to achieve in granting privileges in below case:
>
> TEST1 schema has access to *create, drop and all privilege*s on TEST2
> schema
>
> and
>
> TEST2 schema has access to *create, drop and all privileges* on TEST1
> schema
>
> Please advice.
>
> Thanks,
> RG
>
Other related posts:
- » Re: How to achieve in granting privilege - on one schema to other and vice versa - Ravi Madabhushanam
