RE: Synonyms
- From: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
- To: "Thomas.Mercadante@xxxxxxxxxxxx" <Thomas.Mercadante@xxxxxxxxxxxx>, "jd@xxxxxxxxxxxxxxxxx" <jd@xxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Dec 2010 09:29:50 -0500
It's been declared that public synonyms are bad for any SOX databases where I
work. That means that the DBA's have to comb through any code that needs to be
promoted for the forbidden words 'create public synonym'. It really sucks when
a 3rd party application relies heavily on them. We have to constantly push
code back to them for revision.
Jeremy
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mercadante, Thomas F (LABOR)
Sent: Wednesday, December 01, 2010 9:20 AM
To: jd@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Synonyms
Josh,
I use them all the time. Standard practice here. I used to use public
synonyms but now use private syns. The schema who owns the objects creates
private syns for the users who need them.
Tom
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joshua D. Drake
Sent: Tuesday, November 30, 2010 7:31 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Synonyms
Hello,
Kind of out of left field here but I was curious about how many people
here use Synonyms and the types of synonyms they are normally using,
i.e; table/view/column?
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt
--
//www.freelists.org/webpage/oracle-l
��i��0���zX���+�� n��{�+i�^
��i��0���zX���+�� n��{�+i�^
Other related posts:
