https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889559#M27150 <P>I'm facing an issue where user table authorizations seem to be disappearing randomly, even though there have been no intentional changes made on my end. The setup involves configuring authorizations for each table based on user groups. Additionally, filters and direct parameters are applied for each group and their respective access types.</P><P>The problem arises from the fact that these direct parameters are seemingly wiped out at irregular intervals without any manual intervention. This issue is causing significant disruptions as it's blocking regular operations.</P><P>To give you more context, here's a simplified outline of the process:</P><OL><LI>Users are created and configured via SaaSnow portal which is stable.</LI><LI>Authorizations are established for tables, categorized by user groups.</LI><LI>Filters and direct parameters are meticulously assigned for each group and the specific type of access they require.</LI><LI>Periodically, and seemingly randomly, these direct parameters are inexplicably cleared, even though no changes are deliberately being made.</LI></OL><P>I've thoroughly reviewed logs and configuration settings, but nothing stands out as the obvious cause. We have contact SAS Viya support and they have said that the issue is on our side !!</P><P>Has anyone else encountered a similar situation with SAS Viya?</P> Wed, 16 Aug 2023 21:01:11 GMT akabageni 2023-08-16T21:01:11Z https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889559#M27150 <P>I'm facing an issue where user table authorizations seem to be disappearing randomly, even though there have been no intentional changes made on my end. The setup involves configuring authorizations for each table based on user groups. Additionally, filters and direct parameters are applied for each group and their respective access types.</P><P>The problem arises from the fact that these direct parameters are seemingly wiped out at irregular intervals without any manual intervention. This issue is causing significant disruptions as it's blocking regular operations.</P><P>To give you more context, here's a simplified outline of the process:</P><OL><LI>Users are created and configured via SaaSnow portal which is stable.</LI><LI>Authorizations are established for tables, categorized by user groups.</LI><LI>Filters and direct parameters are meticulously assigned for each group and the specific type of access they require.</LI><LI>Periodically, and seemingly randomly, these direct parameters are inexplicably cleared, even though no changes are deliberately being made.</LI></OL><P>I've thoroughly reviewed logs and configuration settings, but nothing stands out as the obvious cause. We have contact SAS Viya support and they have said that the issue is on our side !!</P><P>Has anyone else encountered a similar situation with SAS Viya?</P> Wed, 16 Aug 2023 21:01:11 GMT https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889559#M27150 akabageni 2023-08-16T21:01:11Z https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889599#M27151 <P>Have you contacted SAS Tech Support? On an old-schools SAS BI environment, i would recommend having a look at the logs of the metadata-server, but i have no idea where Viya logs changes at all.</P> Thu, 17 Aug 2023 08:27:26 GMT https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889599#M27151 andreas_lds 2023-08-17T08:27:26Z https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889604#M27152 Thanks for the advice, I will try to create a ticket for Tech Support to. I can not access the metadata-server with SasViya. Thu, 17 Aug 2023 08:43:30 GMT https://communities.sas.com/t5/Administration-and-Deployment/Users-Table-Authorizations-Disappearing-Randomly/m-p/889604#M27152 akabageni 2023-08-17T08:43:30Z