There are a few ways to view the roles in MariaDB. The first way is to use the SHOW GRANTS statement. This will show you all of the grants that are currently assigned to a user or role. The second way is to use the SHOW ROLE statement. This will show you a list of all of the roles that are currently defined in the database. The third way is to use the SHOW USER statement.