Re: what account does the server use to run sp

From: Andrew Pliszka (apliszkasql_at_alienforceit.com)
Date: 04/28/03

  • Next message: Andrew Pliszka: "Re: SQL Server and virus scanning." 
    Date: Sun, 27 Apr 2003 17:42:08 -0700

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

    Check user's permissions on the table reported in the
    error.

    If the user have no permission to change a table, then sp
    executed by the same user should not have permission
    change the table as well.

    Andrew Pliszka

    >-----Original Message-----
    >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
    >>>
    >>>
    >>
    >>
    >>.
    >>
    >.
    >

  • Next message: Andrew Pliszka: "Re: SQL Server and virus scanning."

    Relevant Pages

    • Re: Deny access to all users (including Administrator and DomainAd
      ... permissions on stored procedure override ... applictaion's user account permissions to the stored procedure which will ... Will try to deny access through the query for SQL Server 2005 and 2000. ... Remove everyone that you don't want rom an Administrator Groups ...
      (microsoft.public.sqlserver.security)
    • Re: public role question
      ... I didn't understand what Dan was asking me to do. ... Then I am able to create a stored procedure. ... system tables with select permissions. ... You ARE the special DBO user, and not the new user, which is why you have ...
      (microsoft.public.sqlserver.security)
    • Re: public role question
      ... I logged on to the database through QA as dantest. ... "Dan Guzman" wrote: ... Windows group and thereby get sysadmin permissions. ... Then I am able to create a stored procedure. ...
      (microsoft.public.sqlserver.security)
    • Re: public role question
      ... Who is the owner of the database? ... "Dan Guzman" wrote: ... Windows group and thereby get sysadmin permissions. ... Then I am able to create a stored procedure. ...
      (microsoft.public.sqlserver.security)
    • Multiple Database Security - How to handle
      ... The problems are security maintenance. ... to the store procedure and permissions to the DM for the ... a stored procedure that accesses DM to get employee info. ... has execute permissions then the procedure is executed as ...
      (microsoft.public.sqlserver.security)