Re: A synonym problem

nolan_at_helios.unl.edu (Michael Nolan) wrote in article

    3hdtu8$4c4_at_crcnis3.unl.edu :

>> Is there a reason why you can't or shouldn't use public
>> synonyms for this? Having a public synonym does NOT make
>> the table itself available to a user if no access has
>> been granted on it. It makes the name of the table
>> public, though.

The inability to grant synonyms through roles is a problem for us as well. Public synonyms are a solution at some of our client sites. However, when managing both project and corporate databases, public synonyms create major conflicts. Creating private synonyms is not difficult, but being able to use roles for the same purpose would be very convenient.

My memory fails me on this, but I seem to recall hearing that the inability to carry synonyms through roles is a reported "bug" that might, eventually, maybe, if they have time, get worked on.

--
Kim Kelln, M.Sc., P.Eng.                  Phone: 403.266.9419
Applied Terravision Systems Inc.            Fax: 403.265.6136
Calgary, Alberta, Canada                  email: kim_at_atsi.com

-- 
Kim Kelln, M.Sc., P.Eng.                  Phone: 403.266.9419
Applied Terravision Systems Inc.            Fax: 403.265.6136
Calgary, Alberta, Canada                  email: kim_at_atsi.com