Re: Stored procedures security
From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 10/27/04
- Next message: JoeBraga: "SQL Profiler beginner"
- Previous message: Chris Chandler: "Seen this but can't remember the fix"
- In reply to: Nikolay Petrov: "Stored procedures security"
- Next in thread: Nikolay Petrov: "Re: Stored procedures security"
- Reply: Nikolay Petrov: "Re: Stored procedures security"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 14:35:50 +0100
SELECT 'GRANT EXEC ON [' + routine_name + '] TO Nikolay'
FROM information_schema.routines
WHERE routine_type = 'PROCEDURE'
AND OBJECTPROPERTY(OBJECT_ID(routine_name), 'IsMSShipped') = 0
Run the above in Query Analyzer with results to text, and run the resulting
script. As long as you haven't granted any permissions to the public role
those are the only permissions your user will have. IF there are, you can
use the above with DENY and information_schema.tables etc.
-- Jacco Schalkwijk SQL Server MVP "Nikolay Petrov" <johntup2_nospam_@mail.bg> wrote in message news:OF4$ISCvEHA.1308@TK2MSFTNGP09.phx.gbl... >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? > > TIA >
- Next message: JoeBraga: "SQL Profiler beginner"
- Previous message: Chris Chandler: "Seen this but can't remember the fix"
- In reply to: Nikolay Petrov: "Stored procedures security"
- Next in thread: Nikolay Petrov: "Re: Stored procedures security"
- Reply: Nikolay Petrov: "Re: Stored procedures security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
