EXEC permission for 'nested' procedure

• real_cals

  SSC Enthusiast

  Points: 191

  More actions

  August 24, 2003 at 7:25 pm

  #84131

  Hiya all

  I have a security conundrum

  Using SQL S. 2000:

  In the Access 2k frontend, using Windows security, the dbo user can run this SP no problems:

  dbo.br_set_calculated_price

  (@jcode VARCHAR(8), @newprice SMALLMONEY, @OUTPUT SMALLMONEY OUTPUT)

  AS

  UPDATE tblmoney

  SET ContractedTotal = @newprice

  WHERE (Jobcode =@jcode)

  DECLARE @Which INT

  EXECUTE dbo.db_update_jobprogress @jcode = @jcode, @QTask = 'Last Calculated', @OUTPUT = @which OUTPUT

  SET @OUTPUT = (SELECT ContractedTotal FROM tblmoney WHERE (Jobcode =@jcode))

  2 things - updates a table value, then logs the change in a table.

  All fine so far. But when a 'normal' user connects, they can run the update table part of the SP, but the logging the change part will not run. It seems that they cannot run the dbo.db_update_jobprogress SP. They definately have exec permissions on both SP's, as well as the relevant tables.

  Am I missing something really basic?

  Thanks heaps (in advance)

  Cals

• real_cals

  SSC Enthusiast

  Points: 191

  More actions

  August 25, 2003 at 2:06 am

  #471168

  Ahhh, I'm very embarrassed

  Sorry - the second exec was failing with no error because of a simple insert problem

  Thanks for reading though!