SingleStore DB

GRANT Syntax using PAM

Grant SingleStore DB privileges using PAM using the following syntax:

GRANT ALL ON *.* to 'singlestore-db_user'@'127.0.0.1' IDENTIFIED WITH
authentication_pam AS 'pam_service';

In the above example, pam_service a placeholder for the actual PAM service name you would like to use. In this example, PAM would look for a config file named /etc/pam.d/pam_service. However, you must change pam_service to the actual service name, do not leave it as pam_service.

Most systems have a PAM service at /etc/pam.d/sshd, so it’s a straightforward way to test SingleStore DB and PAM:

GRANT ALL ON *.* to 'steve'@'localhost' IDENTIFIED WITH
authentication_pam as 'sshd';

This should use the default authentication scheme on the system – the same password a user would use for SSH.