Re: Rights for Linked Server
- From: "Russell Fields" <russellfields@xxxxxxxxxx>
- Date: Thu, 17 Jan 2008 16:55:35 -0500
Jeff,
What are the security settings for your linked server? This is on the
Security table of the linked server form. You can creates a script to
display the linked server definition.
RLF
"jeff" <jeff@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C6D668A6-558A-4B32-B112-AD1C0EE10AF4@xxxxxxxxxxxxxxxx
SQL Server 2005 linked to DB2......
The queries are successful when procs that access data via the linked
server
are run by System Administrator. Standard users get the following...error
code SQL1092N Access Denied.
THKS
.
- Prev by Date: Re: How to add VIEW SERVER STATE permissions
- Next by Date: Record level security?
- Previous by thread: Re: How to add VIEW SERVER STATE permissions
- Next by thread: Re: Rights for Linked Server
- Index(es):
