Re: Synonyms
- From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
- To: gints.plivna@xxxxxxxxx
- Date: Wed, 01 Dec 2010 16:12:44 +0100
Well, I have met systems that were (apparently) trying to defeat this
and confusing everyone by having lots of invalid public synonyms ...
Stephane Faroult
RoughSea Ltd <http://www.roughsea.com>
Konagora <http://www.konagora.com>
RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd>
On 12/01/2010 04:06 PM, Gints Plivna wrote:
> Don't know anything in details about SOX but for especially paranoidal
> (sorry err I mean secure :) ) systems knowing that particular object
> exists without any rights on it could be redundant and dangerous
> knowledge.
>
> At least for projects made by ourselves we almost never used public
> synonyms because to my mind that's really unnecessary knowledge and
> information for ANY user that is already created and will be CREATED
> IN THE FUTURE. Especially the last aspect (future users) can be very
> dangerous both for public synonyms and even more - public rights.
>
> Gints Plivna
> http://www.gplivna.eu
>
> 2010/12/1 <Dominic.Brooks@xxxxxxxxxxxxxxxxxxx>:
>
>> I love those declarations.
>>
>> Surely it's not really public synonyms but granting unnecessary privileges
>> on those objects to public.
>>
>> Is it SOX compliant to have a post release script to remove all public
>> synonyms and replace them with private synonyms for all users?
>>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
Other related posts:
