Re: Stored Procedure and Table permissions

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 06/03/04 

Date: Thu, 03 Jun 2004 07:08:17 -0600

It will work. Make sure the ownership chains are maintained
- in your example, the table and stored procedure need to
have the same object owner. Then you only need to grant
execute permissions on the stored procedure.

-Sue

On Thu, 3 Jun 2004 05:51:47 -0700, "Robert Mooney"
<anonymous@discussions.microsoft.com> wrote:

>I want to:
>
>1. create a user whose only permissions are to run a
>stored procedure.
>
>2. the stored procedure reads specific data from a table -
> allowing the user read-access to the specific data.
>
>I've created the user and the stored procedure. I've
>given the user EXEC permission for the stored procedure.
>But I find I must give the user SELECT permission to the
>table in order for the stored procedure to work - thus
>exposing the entire contents of the table. I'm executing
>the stored procedure from VBA in Excel.
>
>Is there a way to configure permissions so that the user
>only has EXEC permission to the stored procedure but no
>permissions to the table? In that way I can control what
>information the user sees.
>
>Bob Mooney

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)