Re: Execute SP

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 12/23/04

  • Next message: Derrick Leggett: "Re: Developer has SA registration details" 
    Date: Thu, 23 Dec 2004 17:47:49 -0000

    Granting execute permissions to all stored procedures in a database
    http://www.sqldbatips.com/showarticle.asp?ID=8

    sp_grantexec
    http://www.sqldbatips.com/showcode.asp?ID=2 

    -- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Eric Ward" <EricWard@discussions.microsoft.com> wrote in message 
news:74243249-0388-410B-A306-9248A1A60C79@microsoft.com...
> How do I give a roles access to execute a SP?
>
> Let me clarify:
> I know that I can create a role and then go give that role Execute
> permission to all the SP.
>
> I wondering if there is an easier way?
>
>
  • Next message: Derrick Leggett: "Re: Developer has SA registration details"

    Relevant Pages

    • Re: Execute Persmission denied on object sp_OACreate
      ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
      (microsoft.public.sqlserver.security)
    • RE: exec sp_help_job user account rights
      ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
      (microsoft.public.sqlserver.security)
    • Re: SSIS - OLE DB Command - how to retrieve query results ???
      ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
      (microsoft.public.sqlserver.dts)
    • RE: xp_cmdshell, ownership chaining, sql 2000
      ... Cross database ownership chaining enabled ... The procedure is called by a crystal report. ... If I log in to SQL Server through SSMS 2005 using the same user as the ... I get the following error when attempting to execute ...
      (microsoft.public.sqlserver.programming)
    • Re: 3 Simple Security SQL Statements
      ... Kalen Delaney, SQL Server MVP ... window and execute. ... Builds a list of text commands. ... EXEC sp_addrolemember 'WebUsersRole', 'WebUser' ...
      (microsoft.public.sqlserver.security)