![]() ![]() Without the INDEX privilege, user can still create indexes when creating a table using the CREATE TABLE statement if the user has have the CREATE privilege, and user can create indexes using the ALTER TABLE statement if they have the ALTER privilege.Ĭan list all databases using the SHOW DATABASES statement. MariaDB server must have permission to access those files.Ĭan create an index on a table using the CREATE INDEX statement. Also needed to create CONNECT outward tables. Read and write files on the server, using statements like LOAD DATA INFILE or functions like LOAD_FILE(). Hashed password, generated by the PASSWORD() function.Ĭan execute FLUSH statements or equivalent mariadb-admin commands.Ĭan shut down the server with SHUTDOWN or mariadb-admin shutdown.Ĭan show information about active processes, via SHOW PROCESSLIST or mariadb-admin processlist. User (together with Host makes up the unique identifier for this account. Host (together with User makes up the unique identifier for this account. The er table contains the following fields: ![]() See privileges for a more complete view of the MariaDB privilege system. A user may not be granted create privilege at the user level, but may still have create permission on certain tables or databases, for example. Note that the MariaDB privileges occur at many levels. The table can be queried and although it is possible to directly update it, it is best to use GRANT and CREATE USER for adding users and privileges. The er table contains information about users that have permission to access the MariaDB server, and their global privileges. Previously, root was the definer, which resulted in privilege problems when this username was changed ( MDEV-19650). From MariaDB 10.4.13, the dedicated mariadb.sys user is created as the definer of the view. New tools are supposed to use INFORMATION_SCHEMA tables. It is now a view into mysql.global_priv created for compatibility with older applications and monitoring scripts. In MariaDB 10.4 and later, the mysql.global_priv table has replaced the er table, and er should be considered obsolete. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |