Обсуждение: File permissions set when uploaded using file manager
Hi Dave/Team,
When files are uploaded using file manager, access permissions of the file are set to 644.
However, the key file used while connecting to postgresql using SSL, should have access permission 600 or less.
To fix this issue the user has to explicitly modify file permissions via command line.
In server mode, if the user does not have command line access to the pgadmin server, the user is not able to modify permissions.
Should pgadmin set permission to key files to 600 or less?
OR should this be documented as 'Todo' for administrator.
Thanks,
Yogesh Mahajan
EnterpriseDB
On Thu, 20 Oct 2022 at 10:16, Yogesh Mahajan <yogesh.mahajan@enterprisedb.com> wrote:
Hi Dave/Team,When files are uploaded using file manager, access permissions of the file are set to 644.However, the key file used while connecting to postgresql using SSL, should have access permission 600 or less.To fix this issue the user has to explicitly modify file permissions via command line.In server mode, if the user does not have command line access to the pgadmin server, the user is not able to modify permissions.Should pgadmin set permission to key files to 600 or less?OR should this be documented as 'Todo' for administrator.
If you can detect it's a key reliably, I don't see any reason not to do it automatically.