Setup Permissions to export excel

Lope · 2009-04-22

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 · 2009-04-22

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 · 2009-04-22

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

Thanks.

matttrax · 2009-04-22

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 · 2009-04-23

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

Tvis · 2009-04-23

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 · 2009-04-27

It works!

Thanks. :-)

Tomm · 2009-07-07

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 · 2009-07-07

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 · 2009-07-15

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~~

Setup Permissions to export excel

Answers

Categories