OSAUTH Privilege

USAGE

With MariaDB Xpand, the OSAUTH privilege can be granted using the GRANT statement:

GRANT OSAUTH ON *.* to 'xpand'@'localhost';

DETAILS

MariaDB Xpand provides the OSAUTH privilege to configure a database user account to be authenticated by the operating system. When a database user account has the OSAUTH privilege, they can log into Xpand without a password as long as they have been authenticated as the corresponding OS user.

The OSAUTH privilege is granted to certain default user accounts:

• The database management user (xpandm) is granted the OSAUTH privilege to allow clx to be executed without a password

• The database daemon user (xpand) is granted the OSAUTH privilege to allow statd and Xpand GUI to be used without a password

CHANGE HISTORY