remote mysql

We have a cpanel server with a local MySQL server. We have a separate MySQL database server that we have successfully connected as a remote MySQL profile within WHM. How do we / can we assign the second MySQL profile to be used by a specific account? We want specific accounts to operate on...