we created a Windows Login in Navision, and synchronize all security.
while enduser(means not super) want to export excel from NAV,the error shows as follows:
"The following SQL sever errors occurred while accessing the Default Style Sheet Table
229,"4200"[Micosoft][ODBC SQL Sever Driver][SQL Sever]THE SELECT permission was denied on the object "User Default Style Sheet",database"xx",shcema"dbo"
we tried to add tabledata enven table about 20000xx"User Default Style Sheet"in role "all",synchronize it again and could not export also.
BTW,we have met this problem befor in sql2000 and add missing table in sql ,it successed
but in sql 2005/NAV5.0 it could not be solved