Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Allow stored procs only 1

Status
Not open for further replies.

hapax

Programmer
Nov 10, 2006
105
US
How can I restrict my database access to stored procedures only, and only to specific stored procedures that I specify? No plain SQL queries allowed.
 
When you set up the permissions for the user, grant access to stored procedures only and not tables then the user will not be able to perform any select statements.

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top