Re: Stored procedures security

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

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

Relevant Pages

  • Re: Exchange 2007 - problem setting send-as permissions on MBX/PF databases (receive-as
    ... MCITP | EMA; MCSE | M+, S+, ... I seem to have a problem granting send-as access to both the MailboxDatabase ... I can see that the permissions are set via get-adpermission and adsiedit. ...
    (microsoft.public.exchange.admin)
  • 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)