Exec permissions on Stored Procedure

Hi all,

SQL2000 sp4

If I grant EXEC permissions on a Stored Procedure to a Domain User
shouldn't they be able to Execute that stored procedure reguardless if they
have Select permissions
on a table that the Stored Procedure uses?

thanks,
gv


.

Relevant Pages

  • Re: Grant EXEC on Stored Procedure
    ... GRANT EXEC ON TO ... > Using T-SQL how can I grant EXEC permissions to a user in the same ... Is there a system stored procedure that will do this? ...
    (microsoft.public.sqlserver.programming)
  • 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)