Re: How to achieve in granting privilege - on one schema to other and vice versa

From: Ravi Madabhushanam <ravi.madabhushanam_at_gmail.com>
Date: Wed, 16 Jun 2010 09:55:58 +0530
Message-ID: <AANLkTilzPK0bTZpv0iYca9kSUf4QfuWHIdhqzRr-5zuI_at_mail.gmail.com>

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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 15 2010 - 23:25:58 CDT