Symptoms:
When running reports in the BI360 Portal, the user receives the below error:
System.Data.SqlClient.SqlException (0x80131904): The SELECT permission was denied on the object 'FlexDef', database ' ', schema 'dbo'.
Resolution:
In SQL, you will go to the database mentioned in the error search Schema'dbo' > Users >Security> Securables > Search >All objects belong to schema >dbo >Flexdef> then grant "Select"
Properties:
Applies To:
- BI360 Portal 4x