Re: Stored procedures security
From: Jacco Schalkwijk (jacco.please.reply_at_to.newsgroups.mvps.org.invalid)
Date: 10/27/04
- Next message: nospamplease: "collation"
- Previous message: Richard Humphrey: "Re: Backups failing"
- In reply to: Nikolay Petrov: "Re: Stored procedures security"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 17:32:05 +0100
Yep.
-- Jacco Schalkwijk SQL Server MVP "Nikolay Petrov" <johntup2_nospam_@mail.bg> wrote in message news:eRVgvNDvEHA.2316@TK2MSFTNGP15.phx.gbl... > Jacco, this statment will grant execute permission to non MS strored > procedures, right? > > > "Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> > wrote in message news:uIqopnCvEHA.3908@TK2MSFTNGP12.phx.gbl... >> 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: nospamplease: "collation"
- Previous message: Richard Humphrey: "Re: Backups failing"
- In reply to: Nikolay Petrov: "Re: Stored procedures security"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
