Disable ssh system access on all domains

[VictorA]

Hi,

I need to disable system access on all domains of my server (+300). Is there any way to run a command from Plesk database to do it?.

something like:

update dom_param set val = 'true' where param = '';

 

[IgorG]

Victor,

You can find shell for all domains with

select shell from sys_users where id in (select sys_user_id from hosting);

And update with '/bin/false' in sys_users table.