PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-routine-grants-table.html
The ROLE_ROUTINE_GRANTS table (available as of MySQL 8.0.19) provides information about the routine privileges for roles that are available to or granted by the currently enabled roles. The ROLE_ROUTINE_GRANTS table has these columns: GRANTOR The ...SPECIFIC_CATALOG The name of the catalog to which the routine ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-enabled-roles-table.html
The ENABLED_ROLES table (available as of MySQL 8.0.19) provides information about the roles that are enabled within the current session. The ENABLED_ROLES table has these columns: ROLE_NAME The user name part of the granted role. IS_DEFAULT YES or ...
https://dev.mysql.com/doc/refman/8.0/en/grant.html
[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... ] ] } GRANT PROXY ON user_or_role TO user_or_role [, user_or_role] ... These syntax restrictions apply: GRANT cannot mix granting both privileges and roles ...To grant a privilege with GRANT, you must have the GRANT OPTION privilege, and you must have the privileges that you are ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
This takes precedence over default roles specified with SET DEFAULT ROLE. If activate_all_roles_on_login is disabled, the server activates the default roles specified with SET DEFAULT ROLE, if any, at login time. Granted roles include those granted ... The MySQL server maintains many system variables that affect its ...
https://dev.mysql.com/doc/refman/8.0/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
It enables authentication, role, SSL/TLS, resource-limit, password-management, comment, and attribute properties to be modified for existing accounts. Setting the default roles for yourself requires no special privileges, as long as the roles you ...
https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html
Whether a privilege is static or dynamic affects its availability to be granted to user accounts and roles. (The CREATE USER privilege also enables use of the CREATE ROLE statement.) See Section 8.2.10, “Using Roles”. The CREATE ROLE and DROP ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
It enables authentication, role, SSL/TLS, resource-limit, password-management, comment, and attribute properties to be established for new accounts. To assign privileges or roles to this account, use one or more GRANT statements. CREATE USER Role ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
A role that has the SYSTEM_USER privilege cannot be listed in the value of the mandatory_roles system variable. Prior to MySQL 8.0.16, any role can be listed in mandatory_roles. The privileges possessed by a session are those granted directly to its ... As of MySQL 8.0.16, MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...