Reported: July 26, 2017

Version(s) affected: DataSight 3.0 and above

Issue: Users encounter 'db_owner' permission error intermittently when reading and writing data to a database, especially when a user is trying to add/delete a gauging or level.

Workaround: All DataSight users require read and write permissions to a database. The presented issue is most likely the result of 'db_owner' role not being assigned to the user. A DataSight Administrator user with administrative privileges on the Microsoft SQL Server can grant 'db_owner' permission to a user to prevent this issue. Select the user from Security > Logins and assign a 'db_owner' privilege. Please note that this is different from Database > Security > login.

Resolution: Same as workaround suggested above

Last Updated: July 26, 2017