Dear Plesk forum members,
Since Plesk by default doesn't seem to restrict database users to a host / hosts. I know how to set this for new users, and I also know how to alter this setting from the Plesk panel for existing users, but since I have to deal with a lot of existing unrestricted users spread out over multiple servers I would like to automate it a bit.
Therefore I was searching through the psa database to see which table contained the host restrictions, but so far I haven't found it. Does anyone happen to know where I can find this?
Or does anyone know of a CLI command that controls this setting?
Kind regards,
David
Since Plesk by default doesn't seem to restrict database users to a host / hosts. I know how to set this for new users, and I also know how to alter this setting from the Plesk panel for existing users, but since I have to deal with a lot of existing unrestricted users spread out over multiple servers I would like to automate it a bit.
Therefore I was searching through the psa database to see which table contained the host restrictions, but so far I haven't found it. Does anyone happen to know where I can find this?
Or does anyone know of a CLI command that controls this setting?
Kind regards,
David