Security error on View

(0) Share

Report

Posted on by JackieMc

120

I created a view in our DEV environment (based on two tables) and added the view as a datasource to a form. Everything works great.

I migrated my changes to our UAT environment (by coping our model files). In the UAT environment, the required role gets an error "You are not authorized.." on the new view when trying to open the form.

If I right click on the View in DEV and look at associated security roles, everything is as I would expect. In UAT, doing this shows no roles. However, in UAT, the roles I expect have access to the two tables that are used in the View.

Do I have to somehow explicitly give access to the View? I thought access was based on the tables that are used in the View. Do I have to rebuild security in UAT after copying the model files from DEV? (I did a full compile and database sync.)

Using an account that has SysAdmin privileges, the form with this view is fine in UAT and I can open the View in the AOT and get the results I expect.

Any ideas?

All responses (3)

Answers (1)

Suggested answer

JackieMc 120 on at

Like (0)

Report

RE: Security error on View

Thank you so much. I did the X++ compile, created a new CIL and database sync again and this resolved my issue. I really appreciate your help.
JackieMc 120 on at

Like (0)

Report

RE: Security error on View

Yes, I compiled X++ and then created a new CIL and then did a database sync. Yes I restarted the AOS service.

I compared the View and the security role between DEV and UAT and everything is identical. I just don't understand the issue.

I'm going to go through the compile and db sync steps again out of desperation.
Verified answer

André Arnaud de Cal... 291,759 Super User 2024 Season 2 on at

Like (1)

Report

RE: Security error on View

HI JackieMc,

When you mention a full compile, did you both compile x++ coding and then created a full new CIL? After the compilation and DB sync, did you restart the AOS service?