Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-01-29 : 14:58:05
|
| Hi everybody, I am trying to create some views based on synonyms which reference linked servers. I notice that if I try and create a view using a synonym pointing to the a table on the current database then it shows up under the "synonyms" tab. However, if I add a synonym on a linked table, it doesn't show up. Is this a permissions issue or can you not add synonyms to linked tables? Thank you. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-29 : 16:09:15
|
| shows up for me. are you able to select from it? |
 |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-01-29 : 16:15:08
|
| Yes I can select from the synonym. How did you create your linked server and synonym? thanks. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-30 : 09:01:08
|
| Create Synonym mySynonym FOR server.database.schema.object;In the linked server security properties I used connect with logins current security context.Are you admin on both servers? How did YOU configure the linked server? |
|
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-02-02 : 15:26:45
|
quote:
Originally posted by russell
Create Synonym mySynonym FOR server.database.schema.object;In the linked server security properties I used connect with logins current security context.Are you admin on both servers? How did YOU configure the linked server?
No, I'm not admin on both servers, only mine, I only have readonly access on the remote. I create my linked server and synonyms the same way you outline. |
|
|
|
|
|
|
Synonyms don't show up in new views