Re: OBJECT Level Permissions
From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 03/02/04
- Next message: Bent Lund: "Problems with output parameter"
- Previous message: Brian Moran: "Re: OBJECT Level Permissions"
- In reply to: bokey: "OBJECT Level Permissions"
- Next in thread: Uri Dimant: "Re: OBJECT Level Permissions"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 2 Mar 2004 13:58:26 -0000
DECLARE @username SYSNAME
SET @username = '' -- Fill in here
SELECT 'GRANT EXECUTE ON [' + ROUTINE_NAME + '] TO ' + @username
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_NAME NOT LIKE 'dt%'
Run in Query Analyzer with Text output to generate a script, and run and
save the script at your convenience.
-- Jacco Schalkwijk SQL Server MVP "bokey" <mike_bohlken@hotmail.com> wrote in message news:%23eVP8uFAEHA.3456@TK2MSFTNGP09.phx.gbl... > I know how to GRANT permissions to one object at at time. > > But... What is the best way to GRANT EXEC permissions on "all" my stored > procs in the fewest lines possible? > > Thanks > >
- Next message: Bent Lund: "Problems with output parameter"
- Previous message: Brian Moran: "Re: OBJECT Level Permissions"
- In reply to: bokey: "OBJECT Level Permissions"
- Next in thread: Uri Dimant: "Re: OBJECT Level Permissions"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
