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/stored-objects-security.html
By default, when a routine with the SQL SECURITY DEFINER characteristic is executed, MySQL Server does not set any active roles for the MySQL account named in the DEFINER clause, only the default roles. The exception is if the ... Stored programs ...
https://dev.mysql.com/doc/refman/8.0/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 8.0 Options and Variables Deprecated in MySQL 8.0 Options and Variables Removed in MySQL 8.0 This section lists server variables, status variables, and options that were added for the first time, have been ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
By default, when a replication applier thread is started with a user account specified as the PRIVILEGE_CHECKS_USER, the security context is created using default roles, or with all roles if activate_all_roles_on_login is set to ON. You can use ...
https://dev.mysql.com/doc/refman/8.0/en/set-statement.html
Descriptions for the other forms appear elsewhere, grouped with other statements related to the capability they help implement: SET DEFAULT ROLE and SET ROLE set the default role and current role for user accounts. See Section 15.7.1.9, “SET ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-thread-filtering.html
When the Performance Schema checks for a match for each new foreground thread in setup_actors, it tries to find more specific matches first, using the USER and HOST columns (ROLE is unused): Rows with USER='literal' and HOST='literal'. The threads ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-what-is-new.html
A new mechanism for sharing and synchronizing users, roles, and privileges between SQL nodes is available in NDB 8.0, using the NDB_STORED_USER privilege. Roles can also be shared between SQL nodes by issuing the appropriate GRANT NDB_STORED_USER ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
default_roles: This table lists default roles to be activated after a user connects and authenticates, or executes SET ROLE DEFAULT. A given user table row might refer to a user account or a role. The server can distinguish whether a row represents ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
For information about the differences between static and dynamic privileges, see Static Versus Dynamic Privileges.) Changes to the set of active roles within a session take effect immediately, for that session only. The SET ROLE statement performs ... If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-tp-thread-group-stats-table.html
BECOME_CONSUMER_THREAD The number of times thread have been assigned the consumer thread role. BECOME_RESERVE_THREAD The number of times threads have been assigned the reserve thread role. BECOME_WAITING_THREAD The number of times threads have been ... Note The Performance Schema table described here is available as of MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
When partial_revokes is enabled, an extended syntax is recorded in the binary log for GRANT statements, including the current user that issued the statement and their currently active roles. If a user or a role recorded in this way does not exist on ... Prior to MySQL 8.0.16, it is not possible to grant privileges that apply globally except for certain ...