RE: Synonyms

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

--
http://www.freelists.org/webpage/oracle-l



��i��0���zX���+��n��{�+i�^
��i��0���zX���+��n��{�+i�^

Other related posts: