select permission was denied on the object <table name> in SolarWinds Platform Database Manager

The message below, "The SELECT permission was denied on the object '<table name>', database '<OrionDB>', schema 'dbo'."

Via the Database Manager:



The same message can also be seen in loading up the SolarWinds Platform Web Console:

WORKAROUND 1:

1. Open SQL Management Studio, log in using dba
2. Expand your database
3. Expand the "Security" Folder
4. Expand "Users"
5. Right-click the user Properties, Owned schemas tab.
6. Make sure to uncheck

    db_denydatareader
    db_denydatawriter

a. Move to membership tab, user must have db_owner checked.
b. The user account must be a member of the securityadmin server role.

WORKAROUND 2:

1. Use the following commands to grant permissions:
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.  

GRANT SELECT ON [dbo].yourtable TO youruser