Re: User with privilege on a stored procedure in SQL Server 2000 / 200
- From: "Jeff Dillon" <jeffdillon@xxxxxxxxxxx>
- Date: Fri, 12 May 2006 12:13:58 -0700
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;" />
"ss" <ss@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:517AD58E-97C7-49D3-B65A-75391B163472@xxxxxxxxxxxxxxxx
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
.
- Prev by Date: Re: VS.NET 2003, ADO.NET 1.1 and Access 2000: Getting a Concurrency violation
- Next by Date: Crystal Reports Main report and 2 subreports
- Previous by thread: Re: User with privilege on a stored procedure in SQL Server 2000 / 200
- Next by thread: Re: User with privilege on a stored procedure in SQL Server 2000 / 200
- Index(es):
Relevant Pages
|
