Re: what account does the server use to run sp

From: SQL Server Development Team [MSFT] (sqldev_at_microsoft.com)
Date: 04/25/03 

Date: Fri, 25 Apr 2003 10:39:58 -0700

The user that is trying to execute the sp on the new server doesn't have
EXECUTE permissions, or the user was denied select/update/insert permissions
on the table. On the existing production server, determine how the user has
EXECUTE permissions on the stored procedure and duplicate the permissions to
the new server.

Peter Saddow 

-- 
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Steve Anthony" <Santhony@nebraska.edu> wrote in message
news:03bb01c30b3d$129681f0$3401280a@phx.gbl...
> I now that the user needs to have access to a sp to run
> it. But what account does the server use to run the sp.
> Our production server runs the same sp fine. our "new"
> test server when running the same sp gives permission
> errors on the tables that are accessed by the sp. Any
> Idea's
>
>

Relevant Pages

  • RE: Windows 2003 Server - Everyone Group
    ... this folder only accessable by the users in the "special" group. ... Configure User and Group Access on an Intranet in Windows Server ... NTFS files system permissions control ... group that you want to set permissions for, click Check Names to verify the ...
    (microsoft.public.win2000.networking)
  • Fail DBD::Mysql 4.003 installation
    ... This test requires a running server and write permissions. ... permissions, then retry. ... Failed 9/9 tests, 0.00% okay ...
    (perl.dbi.users)
  • Re: Virtual Directory - Permission Denied with fso CopyFile
    ... TestUser (normal user account with same credentials on all machines). ... I created a share on a remote server. ... reviewing it's sharing permissions and security tab permissions "everyone" ... "directory security" tab on the vdir and selecting, edit, edit and manually ...
    (microsoft.public.inetserver.iis)
  • RE: SBS 2003 Outoging Fax Problem w/Error 32028 (Cannot send - fatal error)
    ... 1.Reduce the baud rate of the incoming fax modem and see how it goes. ... Click Permissions and verify that the user attempting to fax has at ... 3.If you have configured the fax client on the Windows XP computer ... On the "Additional Server Types" page, ...
    (microsoft.public.windows.server.sbs)
  • Re: Baffelling RWW problem
    ... "special permissions" and all is good in RWW land. ... Check the configuration on SBS server and client computer as following: ... your ISP DNS server IP should be ...
    (microsoft.public.windows.server.sbs)