Posted by Andrew J. Kelly on 10/01/13 11:40

By default when you add a user they do not have any permissions to do
anything. So just make sure you don't add them to any of the server or
database roles. Then simply GRANT them execute permission on that sp.

--
Andrew J. Kelly SQL MVP


"Grzegorz Danowski" <gdn__na@serwerze__poczta.onet.pl> wrote in message
news:dteimk$1b7$1@inews.gazeta.pl...
> Hi
>
> I have two databases: Customers and Operations. In Customers database I
> have made a view based on a few tables from both Customers and Operations
> (left join - customers without any operations). In the same database
> (Customers) I have created a stored procedure based on the view. Finally
> I'd like to give to some users permission only to exec the stored
> procedure.
>
> Have I to add the users to Customers? If yes, please describe me how to
> limit the users privileges only to execution the stored procedure (no
> rights to open tables or view from Customers).
>
> Regards,
> Grzegorz
>
> Ps. I had sent the post on microsoft.public.sqlserver.security, but I had
> no answer.

[Back to original message]