Skip to content
+1-888-319-3663

COMMUNITY FORUM

Users cannot access data in Excel Spreadsheets created by Excel Builder

Steve Connors asked 5 years ago
Hello,
 
I have users who can publish ERB reports and see the files, but they are unable to access the data.  Currently, they are setup in SQL as DB owners.
 
Any help is appreciated.
 
Thank you,
 
Steve
Answers
Jared Dux Staff answered 5 years ago
Is the user you are referring to their GP user or their Windows user?  Their windows user will need to be setup as a db_owner for the specific database that the Excel report is pulling data from.  We have some documentation online as far as permissions for excel reports: http://www.eonesolutions.com/Manuals/SmartList-Builder/SmartList%20Builder%202016/?page=toc377550957

If you would like to submit an answer or comment, please sign in to the eOne portal.