Re: Are there features on other RDBMS's that it would be good for Oracle to have?

From: Jonathan Lewis <>
Date: Tue, 29 May 2012 07:23:34 +0100
Message-ID: <BCBBC7028C954D7B9CD634C39508C991_at_Primary>

  • Original Message ----- |From: "Hans Forbrich" <> |
|On 28/05/2012 7:36 AM, Nuno Souto wrote:

|> Apologies, forgot to add: in I don't have this problem, just
|> re-confirmed. Only in 10g. Dunno why, "feature"? But the synonym
|> issue is still there, of course. Which is bypassed in my case with the
|> trigger.

|I never did understand why you couldn't assign synonyms to roles.

But what if you use the same synonym name in two different ways and then grant both role to the same user ?

create synonym role1.XXX for schemaA.tableA; create synonym role2.XXX for schemaB.tableB

grant role1, role2 to userU;

Then userU executes

    select * from XXX;


Jonathan Lewis

Author: Oracle Core (Apress 2011)

No virus found in this message.
Checked by AVG -
Version: 2012.0.2176 / Virus Database: 2425/5028 - Release Date: 05/28/12
Received on Tue May 29 2012 - 01:23:34 CDT

Original text of this message