list TO hulda;

GRANT journalist TO berengar WITH ADMIN OPTION;

If a user has been granted a role, they do not automatically obtain all
permissions associated with that role. These permissions are only in use when
the user activates the role with the SET ROLE statement.

TO PUBLIC
---------

MariaDB starting with 10.11
---------------------------

Syntax
------

GRANT <privilege> ON <database>.<object> TO PUBLIC;
REVOKE <privilege> ON <database>.<object> FROM PUBLIC;

GRANT ... TO PUBLIC grants privileges to all users with access to the server.
The privileges also apply to users created after the privileges are granted.
This can be useful when one only wants to state once that all users need to
have a certain set of privileges.

When running SHOW GRANTS, a user will also see all privileges inherited from
PUBLIC. SHOW GRANTS FOR PUBLIC will only show TO PUBLIC grants.

Grant Examples
--------------

Granting Root-like Privileges
-----------------------------

You can create a user that has privileges similar to the default root accounts
by executing the following:

CREATE USER 'alexander'@'localhost';
GRANT ALL PRIVILEGES ON  *.* to 'alexander'@'localhost' WITH GRANT OPTION;

URL: https://mariadb.com/kb/en/grant/https://mariadb.com/kb/en/authentication-from-mariadb-104/https://mariadb.com/kb/en/inet6/https://mariadb.com/kb/en/timestamp/https://mariadb.com/kb/en/flush/https://mariadb.com/kb/en/load-data-infile/https://mariadb.com/kb/en/useful-mariadb-queries/https://mariadb.com/kb/en/str_to_date/https://mariadb.com/kb/en/alter-table/https://mariadb.com/kb/en/create-table/https://mariadb.com/kb/en/create-function/PLACE:

DELIMITER //

CREATE PROCEDURE simpleproc2 (
 OUT param1 CHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_bin'
)
 BEGIN
 SELECT CONCAT('a'),f1 INTO param1 FROM t;
 END;
//
ERROR 1304 (42000): PROCEDURE simpleproc2 already exists

DELIMITER ;

DELIMITER //

CREATE OR REPLACE PROCEDURE simpleproc2 (
 OUT param1 CHAR(10) CHARACTER SET 'utf8' COLLATE 'utf8_bin'
)
 BEGIN
 SELECT CONCAT('a'),f1 INTO param1 FROM t;
 END;
//
ERROR 1304 (42000): PROCEDURE simpleproc2 already exists

DELIMITER ;
Query OK, 0 rows affected (0.03 sec)

URL: https://mariadb.com/kb/en/create-procedure/https://mariadb.com/kb/en/create-view/https://mariadb.com/kb/en/generated-columns/https://mariadb.com/kb/en/dynamic-columns/https://mariadb.com/kb/en/sequence-overview/https://mariadb.com/kb/en/window-functions-overview/