No execution permission with on CodeUnit with id 1

borgy

Dear Nav/Sql experts,

One user of our company gets the following error: "No execution permission with on CodeUnit with id 1".
Its only in the RTC, in the classic client he can do his normal job, same database.

Step 1
I have tried to synchronize, then delete his account and synchronize again.
Then made a new account and synchronize, with no errors.

Step 2
I've tried to do the following on SQL
Drop login, drop schema, drop user in combination with step 1
It doesn't work.

In the security we have a genaral authorization level with the right to execute/run a every codeunit.
CodeUnit 0, execute Yes.

I'm out of options, does anybody know this error?

Kind regards,

André Borgeld

sergisoft

I think the problem is not related with SQL Security. It seems to be something about NAV user role/permissions setup.
¿Did you modified codeunit 1 for any reason? ¿Is this codeunit the "original" codeunit?

borgy

Dear Sergi,

I did not modify the codeunit and other users have no problem in logging in to the RTC.
And like i said the same user can work in the classic client on the same database. You would expect the same error here.

Kind regards,

André

borgy

I think is a migrating issue to the RTC. Anybody got any idea how to solve this?

sunmorningindia

Try to Compile all object.

borgy

Solved. There was a problem with the AD synchronisation.
After compliling there was still no issue with the first codeunit. Althrough a good idea to inspect it.

highspeed427

borgy,

could you enlighten me on what you did in AD to make it work. i have the exact same problem and can not figure out how to fix it. the Classic works fine but the RTC won't

thanks,

Savatage

borgy wrote:

After compliling there was still no issue with the first codeunit

sounds like he Recompiled the codeunit

object designer->codeunits->select all->compile

grober01

We have the same problem and are also not clear on the recommended resolution.

Note that we have also:

1. Recompiled all code Units
2. Synchronized all Logins

multiple times....

Appreciated - g

julkifli33

i also have a problem like that
using administrator , yes it can
but using other user can't
what i do is remove the company name on the user role...
because for administrator login i didnt put company name on his user role

Franklin

That´s a SQL problem with permissions or the user don´t asigned any profile for RTC

tameemabdullah

had the same problem..

The problem occurs when you filter any users permissions by company.

The work around is to give that same user the ALL role with no company filter.

They will be able to login to any company but will not see any data there or be able to open any forms.

Not sure if there is a fix out yet.

mschneider

tameemabdullah wrote:

...
The work around is to give that same user the ALL role with no company filter.

They will be able to login to any company but will not see any data there or be able to open any forms.

But when they Login to another Comany, the RTC crashes and won't open again. Because it will try to open the last comany.

I have a workaround for that problem. You must create a User Personalization Entry in the database. Then the user can start the rtc.

navuser1

Add Role "ALL" to the User and synchronize.
I have solves the same issue in this way. (Ref--http://dynamicsuser.net/forums/p/40739/208678.aspx)

jbolks

Role all is a work-around, not the solution. Problem is that you like to show only 1 of the companies.

Solution is to create 1 role:
- for example super => company A and assign this to user A
Go to Application Setup: RoleTailered Client and create for this user a user personalization.

Then the problem is solved