December 01, 2020, 09:45:11 pm
News: IF YOU ARE A MEMBER FROM THE ORIGINAL SITE AND CAN'T LOGIN. POST IN THE FEEDBACK FORUM (AS GUEST) AND AN ADMIN WILL ASSIST YOU TO ACCESS THE SITE!
Pages: [1]   Go Down
Author Topic: SQL Server 2005 - Database roles/permissions  (Read 3329 times)
Slowhand
Supporters
*

Stars: +0/-0
Offline Offline

Gender: Male
Awards:
Topic Necromancer
Posts: 4668


I code C#!


WWW
« on: July 04, 2008, 01:24:36 pm »

Hi,

I'm building a small web application that connects to an MS SQL server.
Now to minimize risks I want to create a database user that can do only one thing: execute stored procedures (just one SP to be precise)
Can this be done?
If so, how?

Cheers,
CJ
Logged


wrack
Master of TMEOotAP
*

Stars: +3/-0
Offline Offline

Posts: 11116


Don't look back. Look in the mirror to look back.


WWW
« Reply #1 on: July 04, 2008, 03:31:56 pm »

Very easy Slowy.

You create the stored procedure and a user to whom you want to allow access to a given stored procedure.

Then you right click on the stored procedure in management studio and click properties.

Go Permissions and add the user by clicking the add button. Then at the botton of that screen you tick the "Grant" box against "Execute" option.

Press OK and off you go smile
Logged

Pages: [1]   Go Up
Print
 
Jump to: