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

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


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

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

Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com/all_postings

Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543



No virus found in this message.
Checked by AVG - www.avg.com
Version: 2012.0.2176 / Virus Database: 2425/5028 - Release Date: 05/28/12
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 29 2012 - 01:23:34 CDT

Original text of this message