Re: what account does the server use to run sp

From: steve anthony (santhony_at_nebraska.edu)
Date: 04/25/03 

Date: Fri, 25 Apr 2003 11:25:40 -0700

Permissions have been matched. Its not that the sp doesn't
run I get permission error on the table that are used in
the stored procedure.

>-----Original Message-----
>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)
  • Re: With in a SP Truncate dbo.table table-name permissions..
    ... TRUNCATE TABLE permissions default to the table owner, ... According to sql server ... If a user who creates a stored procedure does ...
    (microsoft.public.sqlserver.security)
  • 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)