Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login
    1. Home
    2. MY_9476
    3. Topics

    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!

    M Offline
    • Profile
    • Following 2
    • Followers 0
    • Topics 3
    • Posts 8
    • Groups 0

    Topics

    • M

      SQL Execute Permissions Missing for LogMessages_PurgeOldMessages

      Watching Ignoring Scheduled Pinned Locked Moved Support
      2
      1 Votes
      2 Posts
      11 Views
      atrippA
      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 @SQL The script you ran works too :)
    • M

      Otter: Eliminate extraneous changes from the "Review Changes..." screen

      Watching Ignoring Scheduled Pinned Locked Moved Support
      5
      1
      0 Votes
      5 Posts
      8 Views
      M
      OK, Dean, thank you very much.
    • M

      Unable to save changes to Role Configuration Script in Otter 2023 and 2023.1 (Build 3)

      Watching Ignoring Scheduled Pinned Locked Moved Support otter
      7
      1
      0 Votes
      7 Posts
      33 Views
      M
      @rhessinger, I can confirm that 2023.3 has fixed the issue. Thank you very much!
    • 1 / 1