Role "All" not complete in NAV 5.0

tinoruijs

Don't know if this post belongs in Tips & Tricks...

Just got an error when setting up rights in NAV 5.0.
I setup an user with rights for Sales Orders. And added the role All.
When the user logs in the following error is shown.

The following SQL Server error(s) occurred while accessing the License Agreement table.

229,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]The SELECT permission was denied on the object 'CompanyName$License Agreement', database 'DatabaseName', schema 'dbo'.

Solution is to add rights for tabledata 140 (new 5.0-table License Agreement) to role All. And then synchronize logins.

tinoruijs

And when closing the session of the user I received a error "Date not valid".
This error is now also gone after changing role All.

nunomaia

LoginStart function uses that table.
Std. permissons are far from be completed

tinoruijs

nunomaia wrote:

LoginStart function uses that table.
Std. permissons are far from be completed

Yes. Noticed that..

Alex_Chow

A better question is "when were the permissions in all releases since 3.x complete?".

nunomaia

Alex Chow wrote:

A better question is "when were the permissions in all releases since 3.x complete?".

A must-have in future releases. In Next version permissons will get more complex. It would help having a good std base to begin.

tinoruijs

Alex Chow wrote:

A better question is "when were the permissions in all releases since 3.x complete?".

It's the first time I'm actually setting up logins and roles from scratch.
And I never heard the consultant complain before..
The really be a :x .

Alex_Chow

Yeah... I think all the consultants are used to it and have alloted time to address permissions.