Re^2: Public synonym problem

+++ mlanda # vnet.ibm.com_at_2:240/5889 +++ "Re: Public synonym problem"

m>
m> Creating a public synonym for a table does not give users access to that
m> table. It only lets them refer to a table using a synonym instead of the
m> actual table name. You (user scott in this case) needs to grant your other
m> users access to table scott.emp before they will be able to use this table.

AND by the way, the 'older' versions of ORACLE (7.0.13 i. eg.) didn't work propperly with synonyms.

It's highly recommended to follwow (may be even with 7.1.x or 7.2.x) this procedure :

• Create the table FIRST.
• THEN grant whatever to anyone.
• AND THEN (not earlier) create the synonym.

Any other procedure ended in BAD results on our site. KEEP IN MIND that dropping a table does NOT drop the synonym(s) as well (like it would with triggers and indexes).

So in these cases, the synonym(s) pointers will show you the way to Moscow or ANY other place, but (by experience instead of ORACLE-manual) never show the contents of your table/view.

Regards Karl

FIDO : 2:240/5840.3
MAIL : 100666.3450_at_compuserve.com Received on Mon Nov 20 1995 - 00:00:00 CET