MariaDB/SQL/GRANT
Jump to navigation
Jump to search
Related
REVOKE
negates privileges granted byGRANT
.SHOW GRANTS
lists privileges granted byGRANT
. (seeSHOW
)
Reference
Example
GRANT ALL ON roundcube.* to 'rc-bot'@localhost;
Syntax
GRANT
<priv list>ON
<object type> <priv level>TO
<user spec> [ <user options> ]- <priv list>: <priv_type> [ <column_list> ] [, repeat...]
- <priv_type>: one of –
USAGE
ALL
[PRIVILEGES
]
- <object type>: one of –
TABLE
FUNCTION
PROCEDURE
PACKAGE
PACKAGE BODY
- <priv level>: one of –
*
*.*
- <db_name>
.*
- <db_name>
.
<tbl_name> - <tbl_name>
- <db_name>
.
<routine_name>
- <user spec>: one of –
- <username> [ <authentication option> ]
PUBLIC
- <authentication option>: one of –
IDENTIFIED BY
'<password>'IDENTIFIED BY PASSWORD
'password_hash'IDENTIFIED
{VIA
|WITH
} <authentication rule> [OR repeat...]
- <user option>: one of –
REQUIRE
{NONE
| <TLS option> [[AND
] repeat...]- [
WITH
<with option> [repeat...]
- <with option>: one of –
GRANT OPTION
- <resource_option>
GRANT
<rolename>TO
<grantee> [, repeat...] [WITH ADMIN OPTION
]- <grantee>: one of –
- <rolename>
- <username> [ <authentication option> ]
- <grantee>: one of –