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

Tech-Archive recommends: Fix windows errors by optimizing your registry

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.

"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


.

Relevant Pages

  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: SQLserver and the WHERE x IN y
    ... to a stored procedure - that would only work if you introduced subtyping into ... the temp table from the calling procedure (the temp table is still in scope, ... INSERT INTO #MyTempTable EXECUTE YourPopulateProc 123 ... INSERT INTO @MyTableVar VALUES ...
    (microsoft.public.sqlserver.programming)
  • RE: SQL stored procedure executing twice
    ... caused the stored procedure to execute twice. ... from one parent record to another. ... Dim stDocName As String ... The table tempCount does not change until I execute the VBA code line: ...
    (microsoft.public.access.modulesdaovba)
  • Re: pass stored procedure parameters in asp
    ... you can use the EXECUTE AS statement to test the ... procedure and properties) of voidTran stored procedure and other ... This email account is my spam trap ...
    (microsoft.public.inetserver.asp.general)
  • RE: Stored Procedure performance
    ... >Subject: RE: Stored Procedure performance ... >>In this way the Stored Procedure would only execute once and not on all ... >>On Behalf Of Colin Dawson ...
    (comp.databases.informix)