I came up with a set of functions that I would like to be accessed from a variety of places. SQL seemed like the best place for this due to accessibility, but I receive this error when trying to use them with a user with only the db_datawriter
and db_datareader
permissions: "The EXECUTE permission was denied on the object"... etc etc
I want to pass a date and return other dates. Apparently I can't just
SELECT [dbo].[fn_Acct_Day_One] ('1/3/2015')
Any way I can do this without granting db_owner
to the user?