Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
SQL Execute Permissions Missing for LogMessages_PurgeOldMessages
-
Hello,
I've noticed the following error message after upgrading to Otter 2024.2 (Build 1).
Unhandled exception: The EXECUTE permission was denied on the object 'LogMessages_PurgeOldMessages', database 'Otter', schema 'dbo'.
LogRetentionTaskRunner
I fixed it by granting the EXEC permission on that stored procedure to the database role OtterUser_Role, similar to the other stored procedures.
If I recall correctly, I had to apply the same fix after the previous upgrade as well.
-
Hi @MY_9476 ,
Thanks for the heads up! We will fix this via OT-514 in the next maintenance release.
As an FYI, this is the code that should have been run at the end of the database upgrade, to ensure that all procs and table-value params have appropriate permission:
DECLARE @SQL NVARCHAR(MAX) SET @SQL = '' SELECT @SQL = @SQL + 'GRANT EXECUTE ON TYPE::' + QUOTENAME(name) + ' TO [OtterUser_Role] ' FROM sys.table_types SELECT @SQL = @SQL + 'GRANT EXECUTE ON ' + QUOTENAME(name) + ' TO [OtterUser_Role] ' FROM sys.procedures EXEC sp_executesql @SQLThe script you ran works too :)
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login