User with privilege on a stored procedure in SQL Server 2000 / 200

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i create a strored procedure where a perticular user only should have
the permission to execute?

To execute that stored procedure in the client application, how do i specify
my privileges in the ADO.NET which i will be using in ASP.NET web application?

Can anybody show one simple example?

bye
Thanks,
ss
 
When you execute the stored procedure you don't need to do anything. Since
you will be logging in as that particular user in the connection string,
that will automatically enforce all the rights set up for that user.
 
In SQL Enterprise Manager, right click on the Sproc name and choose Manage
Permissions from All Tasks

Then turn on Basic Auth on your web app, with Identity Impersonate = True in
your web.config.

Use Integrated Security in your connection string, similar to:
<add key="DBConnectionString" value="data source=servername;initial
catalog=databasename;integrated security=SSPI;persist security
info=False;packet size=4096;timeout=180;Max Pool Size=200;" />
 
Marina,

I saw some weeks ago somebody advising here or in the ADONET newsgroup to
use a general SQL user with non integrated security.

You know my reaction of course.

Cor
 
How do i create a strored procedure where a perticular user only should have
the permission to execute?

To execute that stored procedure in the client application, how do i specify
my privileges in the ADO.NET which i will be using in ASP.NET web application?

Can anybody show one simple example?

bye
Thanks,
ss
Click to expand...
These are issues that must be handled from the SQL Server Enterprise Manager.
You will improve your chances of getting an answer by posting to one of those
news groups. Although, you might want to type TSQL into the IDE's Help section
and then look for the keywords regarding your questions which are basic SQL
Server security questions.

Good luck with your project,

Otis Mukinfus
http://www.arltex.com
http://www.tomchilders.com
 
Back
Top