Re: INSERT Permission & Linked Servers

Craig Wagner (MSDNNospam207@xxxxxxxxxxxxx) writes:
Thank you for the suggestion. I tried granting VIEW DEFINITION to that
table but I still got the same message.

One other data point that I discovered after my original post. The table
into which I'm inserting has a primary key. If the value I'm trying to
insert does not already exist, I get the message in my original post. If
I try to insert a duplicate value I get a message that is much more to
the point.

Msg 229, Level 14, State 5, Line 1
The SELECT permission was denied on the object 'SampleTable', database
'Sample', schema 'dbo'.

Then it seems that the provider is running some query with SET FMTONLY ON
to get information. You can use Profiler on the remote server to see what
the originating server emits.

If it uses SELECT, then the users would need SELECT permission.

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • RE: Feature request; performance dashboard report
    ... SQL Server Tools General ... SQL Dev team when you had the original post at the community, ... could not get their response at that time. ... to reset the underlying DMVs back to a clean state. ...
    (microsoft.public.sqlserver.tools)
  • Re: user defined Role - HELP
    ... does not have permission on tblUReport" am thoroughly stumped on why it ... This is because ownership chaining does not apply to TRUNCATE TABLE. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: Public Role for SQL 2000
    ... I tried to Revoke Select permission but not able to do that. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • RE: How long does the typical DBA wait to apply a SQL Server Service P
    ... original post. ... We are on SQL Server 2008 (No Service Packs) and recently encountered a bug ... that Microsoft fixes in one of their cumulative updates for SQL Server 2008. ... we realized there was a service pack after the cumulative update, ...
    (microsoft.public.sqlserver.setup)
  • Re: How to generate drop and recreate index script in SQL Manageme
    ... In your original post, you talked about dropping tables and indexes, and ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)