A Public synonyms can be accessed by any user on the database

greenspun.com : LUSENET : DBAzine : One Thread

what ia a synonym actually what is the difference between a public or private synonym and make more clear the statement that public synonym can be accessed by any user in the database

-- harish awasthi (awasthi_harish@yahoo.com), November 02, 2003

Answers

a private synonym is just for the use of the one creating it. a public synonym is for the general public (everyone) to use.

-- Steve Pratt (steve_pratt@isp.state.il.us), August 30, 2004.

Moderation questions? read the FAQ