Re: How to give execute permissions to all stored procedures in the database?
From: David Browne (meat_at_hotmail.com)
Date: 11/24/03
- Next message: lori: "home page"
- Previous message: Abraham: "How to give execute permissions to all stored procedures in the database?"
- In reply to: Abraham: "How to give execute permissions to all stored procedures in the database?"
- Next in thread: Louis Davidson: "Re: How to give execute permissions to all stored procedures in the database?"
- Reply: Louis Davidson: "Re: How to give execute permissions to all stored procedures in the database?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 24 Nov 2003 16:29:35 -0600
>"Abraham" <binu_ca@yahoo.com> wrote in message
news:u3uKWltsDHA.424@TK2MSFTNGP11.phx.gbl...
>How to give "execute" permissions to all stored procedures in the
database?( looking to give >permissions to all at a time )
>Is there any database roles in SQL server ( like db_ddladmin ..) other
than db_owner .
Here's what I do:
in QA, set results as text and run
set nocount on
select 'create procedure GRANT_PERMISSIONS as'
select 'grant execute on ' + name + ' to [user]' from sysobjects where type
in ('p') order by name
to output a script. Copy and run it. Then run the new GRANT_PERMISSIONS
procedure.
David
- Next message: lori: "home page"
- Previous message: Abraham: "How to give execute permissions to all stored procedures in the database?"
- In reply to: Abraham: "How to give execute permissions to all stored procedures in the database?"
- Next in thread: Louis Davidson: "Re: How to give execute permissions to all stored procedures in the database?"
- Reply: Louis Davidson: "Re: How to give execute permissions to all stored procedures in the database?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
