Re: Stored procedures security

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 10/27/04

Next message: Keith Kratochvil: "Re: Stored procedures security"
Previous message: Nikolay Petrov: "Stored procedures security"
In reply to: Nikolay Petrov: "Stored procedures security"
Next in thread: Keith Kratochvil: "Re: Stored procedures security"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 27 Oct 2004 15:20:37 +0200

> I have db where I want a specified user to be allowed only to run stored
> procedures.
> How to grant permissions to these stored procedures and deny access to all
> other functions?

Give the users only EXECUTE permission on the SPs and no other permissions.
Check how to do it in the "Managing Permissions" topic in Books OnLine.

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Next message: Keith Kratochvil: "Re: Stored procedures security"
Previous message: Nikolay Petrov: "Stored procedures security"
In reply to: Nikolay Petrov: "Stored procedures security"
Next in thread: Keith Kratochvil: "Re: Stored procedures security"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

Re: Allow users to update their own AD attributes?
... Instead of granting permissions to a specified user, ... as the user you want to grant perms to. ... and I sure don't> want to go manually changing permissions on 9,000 user accounts to allow> specific edits... ...
(microsoft.public.windows.server.active_directory)
Re: Send as?
... How about posting what you did? ... Hank Arnold ... >> send as the specified user" message. ... I have checked all permissions but I ...
(microsoft.public.exchange.admin)
RE: SBS 2003
... You would set custom permissions for the specified user. ... Set the Sharing permissions to Domain Users Full Control. ... Microsoft Windows Small Business Server 2003 ...
(microsoft.public.windows.server.sbs)
Re: Stored procedures security
... > I have db where I want a specified user to be allowed only to run stored ... > How to grant permissions to these stored procedures and deny access to all ... Give the users only EXECUTE permission on the SPs and no other permissions. ... Dejan Sarka, SQL Server MVP ...
(microsoft.public.sqlserver.server)
Re: Stored procedures security
... > I have db where I want a specified user to be allowed only to run stored ... > How to grant permissions to these stored procedures and deny access to all ... Give the users only EXECUTE permission on the SPs and no other permissions. ... Dejan Sarka, SQL Server MVP ...
(microsoft.public.sqlserver.programming)