Setup Permissions to export excel

Lope

Hi All,

I'm doing some roles to each user login. When any user tries to export to excel a sales order this system message is shown:

"The SELECT permission was denied on the object 'User default Style Sheet'"

The roles have premission of read/write in that table. What another permissions are necessary?

Thanks.

matttrax

This is a bug that is fixed with 5.0SP1. So you'll have to do an executables upgrade.

Even if you sign permission to the tables directly they are not created in SQL. Only works if you are SUPER user. Good testing job Microsoft

Lope

The problem is that we are using the 5.0SP1 executables. ¿?¿?

Thanks.

matttrax

I'd imagine you are using 5.0 and not 5.0 SP1. You need to be on 5.0 SP1 for it to work correctly.

Lope

I'm on 5.0 SP1, and the database is in a SQL Server. :-?

Tvis

My guess is that you are using the Enhanced security model --> if that is the case shift to Standard and it should work.

I had this bug on a 5.0 SP1 SQL system that was running Enhanced security model.

Lope

It works!

Thanks. :-)

Tomm

Hello,
I have the same problem with setting up permission to export to Excel using the excel button.
Moreover we need the Enhanced Security model on this database.

Does anybody a possible solution?
thankx in advance
Tomm

jannestig

Read the following two Hotfixes releases both mention resloutions to the issue mentioned


NAV 5.1

https://mbs.microsoft.com/knowledgebase ... LSULRSXSSP

NAV 5.0

https://mbs.microsoft.com/knowledgebase ... SPLQQTZXPQ

sophiebei

jannestig wrote:

Read the following two Hotfixes releases both mention resloutions to the issue mentioned


NAV 5.1

https://mbs.microsoft.com/knowledgebase ... LSULRSXSSP

NAV 5.0

https://mbs.microsoft.com/knowledgebase ... SPLQQTZXPQ

hi Jannestig

could you give some more details about this problem?tks~~