About ronnynch

ronnynch · ‎07-16-2025

Hi @Kurt_Bremser, The issue is at the OS permission. Thanks for the solution.

ronnynch · ‎07-15-2025

Hi @Kurt_Bremser , We assigned the library to the metadata server, refer to the attachment. Thanks.

ronnynch · ‎07-14-2025

Hi @gwootton, Thanks for the reply. I have checked the settings in the Advanced -> Explore Authorizations. User do have the write/drop access. However, he hit authorization level error when he runs his query. I have attached the screenshot of the user's permission setting and the error. Any idea why this is happening? Thanks.

ronnynch · ‎07-14-2025

Hi All, I have a user reported to me that he is unable to overwrite/drop a table from his library. Upon checking the permission, I found out that he is in 2 different user group that are assigned to the library. The first user group allows him to read/write/drop table from the library. The second user group only allows him to read. Is this the reason he is not able to write/drop a table in the library? I have attached the screenshot of the 2 group. Appreciate if anyone can advise. Thank you.

ronnynch · ‎06-05-2025

Hi All, I would like to ask if there is a log captured when a user access has been removed from a library or a user group? I have user reported that he suddenly not able to access to a library. Upon checking, it is confirmed that his does not have access to the library. Issue is, he insists that he has the access to the library previously. Do metadata logs capture the event where the user access was removed? Thanks.

ronnynch · ‎11-11-2024

Hi @carl_sommer , I tried running the %mdsecds(membertypes="Library"); command but hit errors below: ERROR: Physical file does not exist, H:\SASWork\_TD32436_DCVWAPSASP_\#LN00074. ERROR: Encountered during XMLInput parsing at or near line 1, column 1. ERROR: The definition for the "MEMBERS" table is not well-formed or is corrupt. Any idea?

ronnynch · ‎10-30-2024

Hello Everyone, I am running on SAS OA 9.4 M8. I would like to know if there's a way for me to generate a report on the user group access. For example, I have 20 user groups, and I want to know which libraries each of the user group have access to. Thanks.

ronnynch · ‎08-04-2024

Hi Kurt, Is there any foreseeable issue if I don't shut down my SAS server? The plan is to let the current production server run as per usual while we do the testing on the temporary server. Thanks.

ronnynch · ‎08-02-2024

Thanks @michele_sas. We just want to restore to a temporary server with different hostname and IP address and perform some testing. No changes to the current server.

ronnynch · ‎08-02-2024

Hi Kurt, We just want to ensure our enterprise backup tool is working. So, the plan is the backup the current production SAS server and restore to another temporary server with different hostname and IP address and perform some testing there. We will not change anything to the current production server. Thanks.

ronnynch · ‎08-02-2024

Hello Everyone, I am trying to simulate a restoration procedure for my current SAS server. Currently, I am running on SAS 9.4M8 on Windows Server 2019. I want to backup the server and restore all the content to another server with different hostname and IP address. My question is, how do perform the update on SAS itself to reflect the new hostname and IP address? Is updating the information via hostname reference is sufficient? Thanks.

ronnynch · ‎09-28-2021

Hi Everyone, I would like to know if there's a way to check who created a user or group. In my organization, there are multiple admin that have the rights to create a user or a group. It would be great to know which particular user did the creation. Thank you.

Online Status	Offline
Date Last Visited	‎07-16-2025 10:14 PM

Re: SAS Authorization

Re: SAS Authorization

Re: SAS Authorization

SAS Authorization

Users removed from accessing the library

Re: Generate Report on User Group Access

Generate Report on User Group Access

Re: Restoring SAS to another Server

Re: Restoring SAS to another Server

Re: Restoring SAS to another Server

Re: Generate Report on User Group Access

Re: SAS Authorization

Re: SAS Authorization

Re: SAS Authorization

SAS Authorization

Users removed from accessing the library

Re: Generate Report on User Group Access

Generate Report on User Group Access

Re: Restoring SAS to another Server

Re: Restoring SAS to another Server

Re: Restoring SAS to another Server

Restoring SAS to another Server

How can I check who created a user or group?