Execute permission on table 2000000073

Falconettifer

Hi,

I created a new database on Dynamics NAV 2009 with SQL Server, restore a backup and it works correctly on the Classic Client.

I set up the configuration file and when I run the RTC, this is the error I had:

"No execute permission on object number: 2000000073 of type: Table"

I tried to solve it by restarting the Dynamics NAV server, also restarting the computer ](*,)

Nothing worked...

Can anyone help me?

Thanks in advance,

Fer

matttrax

What's your security model? Maybe you need to synchronize.

Falconettifer

matttrax wrote:

What's your security model? Maybe you need to synchronize.

SQL Server configured on Mixed Mode (Windows Authentication and SQL Server Authentication)

One user with Windows Login and one user with SQL Server login.

The Database logins are already sinchronized... :?

mihail_kolev

You need to add permissions in the database users (that database used by the company)

DenSter

That's the User Personalization table. Did you get your license updated to NAV 2009?

Ravi_Thakkar

You must have to upload the NAV 2009 Licence on your database.
It will definately solve your problem.

snehalppatel

I am facing the same problem. We have Development Server, where we store the Development Database centrally. When I try to connect the Database using RTC from my local machine, I am able to do it, but when I try to connect the same Database using RTC from my Development Server it gives error "No execute permission on object number: 2000000073 of type: Table".

Please note that I have given SUPER user rights to both windows logins (i.e. my local machine user and the development server user). But still, I am not able to access the Database using RTC from Development Server.

Thanks in advance.

P.S.: My License is for NAV 2009, which is also uploaded on the Database.

Franklin

Hi, i have the same problem with mi partner license updated...

I could i solve this problem? its very strange ](*,)

matttrax

Are you on a 2-tier or 3-tier setup?

If it's 3-tier it could be passing a different user id between the NAV Server and the Database. Check the event log and you should be able to see what user it is connecting with.

snehalppatel

Its 3-tier architecture. I have already checked the Event Log, it isn't giving any Error. If you note my query, you would be able to understand that I am able to connect that Server DB using RTC from other Systems, but not from the one on which the Server DB resides (i.e. the Server itself).

Franklin

Do you have deleted some profiles? I have solved this problem and the cause was that i have deleted some profiles... I have generated all again and everything is ok!!

snehalppatel

No, I haven't deleted any profile. ](*,)

Can you please tell me how did you generated all profiles once again? Thanks.

Franklin

Well, I think the problem is in the configuration of the profiles...

I had this problem when:

1.- The Profile Card, for example President, have as owner DOMAIN/Administrator

2.- The User Personalization Card of DOMAIN/Administrator have a profile id other profile but not President.

Then i deleted all User Personalization Cards and i selected the same users in both forms...

If role President have as owner DOMAIN/Administrator in then Profile Card, then, the User Personalization Card of DOMAIN/Administrator must have the id profile DOMAIN/Administrator.

I think that this error is produced by something like this but not the license because finally i haven´t this problem, and i haven´t replaced any license.

To generate the profiles, i copy the profile from other company.

snehalppatel

Thanks for all the information. I resolved my problem in following way:

In order to allow the user to use Role Tailored Client, there is a role called "BASIC" that must be assigned to the user. What my mistake was, I had given Company Name against that Role, which was restricting the user to access those tables which are necessary to execute in order to run Role Tailored Client. As soon as I removed Company Name against that role of the user, it started working.

venu258

Hi Guys,

can I assign the BASIC role to a super user. I have a requirement to restrict one of the super user to access only one company in RTC. is it possible to do it? I tried to do it as shown in the image , but it didn't work.

Thanks in advance........

mohana_cse06

venu258 wrote:

I have a requirement to restrict one of the super user to access only one company in RTC. is it possible to do it?

Assign the Company to role Super and restart the service