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 Rhinorhino 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
Joined
Nov 10, 2006
Messages
105
Location
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