[Vtigercrm-developers] Create Reports permission denied for non-admin user?

[Sukhdev Mohan]

I think I've the same situation. Will let you know more tomorrow.

Il dom 17 gen 2021, 13:36 Alan Lord <alanslists at gmail.com> ha scritto:

> On 17/01/2021 10:27, Alan Lord wrote:
> >
> > I too am confused by this. I will do some more digging to see why/where
> > these values are being set.
> >
>
> This is weird. I have quite a lot of vtiger systems on one of my dev
> servers and I checked quite a few of them and found many had permissions
> = 1 for CreateView where tabid = 25 in the
> vtiger_profile2standardpermissions table.
>
> Once I clicked "edit" and then saved the profile the permissions were
> set correctly. Due to this query from the Profile Record Model:
>
> > UPDATE vtiger_profile2standardpermissions
> > SET permissions = CASE
> > WHEN operation = 0 THEN 1
> > WHEN operation = 1 THEN 0
> > WHEN operation = 2 THEN 0
> > WHEN operation = 4 THEN 0
> > WHEN operation = 7 THEN 0
> > ELSE permissions END
> > WHERE profileid = 2 AND tabid = 25
>
>
> So it seems to me this might be a problem during the initial
> installation process... And if you do not edit and resave the profile(s)
> then it never gets updated?
>
> Bingo:
>
>
> https://code.vtiger.com/vtiger/vtigercrm/blob/master/modules/Migration/schema/701_to_710.php#L348
>
> Look at that :-)
>
> Al
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210117/a910c41a/attachment.html>