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/roles.html
Like user accounts, roles can have privileges granted to and revoked from them. A user account can be granted roles, which grants to the account the privileges associated with each role. The following list summarizes role-management capabilities ...
https://dev.mysql.com/doc/refman/8.0/en/set-role.html
SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... } SET ROLE modifies the current user's effective privileges within the current session by specifying which of its granted roles are active. Granted roles include those granted ...
https://dev.mysql.com/doc/refman/8.0/en/set-default-role.html
SET DEFAULT ROLE {NONE | ALL | role [, role ] ...} TO user [, user ] ... For each user named immediately after the TO keyword, this statement defines which roles become active when the user connects to the server and authenticates, or when the user ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
DROP ROLE removes one or more roles (named collections of privileges). To use this statement, you must have the global DROP ROLE or CREATE USER privilege. When the read_only system variable is enabled, DROP ROLE additionally requires the ...As of ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
MySQL role names refer to roles, which are named collections of privileges. Role names have syntax and semantics similar to account names; see Section 8.2.4, “Specifying Account Names”. Role names differ from account names in these respects: ...
https://dev.mysql.com/doc/refman/8.0/en/create-role.html
CREATE ROLE [IF NOT EXISTS] role [, role ] ... CREATE ROLE creates one or more roles, which are named collections of privileges. To use this statement, you must have the global CREATE ROLE or CREATE USER privilege. When the read_only system ...The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-column-grants-table.html
The ROLE_COLUMN_GRANTS table (available as of MySQL 8.0.19) provides information about the column privileges for roles that are available to or granted by the currently enabled roles. The ROLE_COLUMN_GRANTS table has these columns: GRANTOR The user ...The value can be any privilege that can be granted at the column level; see Section 15.7.1.6, “GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-administrable-role-authorizations-table.html
The ADMINISTRABLE_ROLE_AUTHORIZATIONS table (available as of MySQL 8.0.19) provides information about which roles applicable for the current user or role can be granted to other users or roles. The ADMINISTRABLE_ROLE_AUTHORIZATIONS table has these ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-table-grants-table.html
The ROLE_TABLE_GRANTS table (available as of MySQL 8.0.19) provides information about the table privileges for roles that are available to or granted by the currently enabled roles. The ROLE_TABLE_GRANTS table has these columns: GRANTOR The user ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-applicable-roles-table.html
The APPLICABLE_ROLES table (available as of MySQL 8.0.19) provides information about the roles that are applicable for the current user. The APPLICABLE_ROLES table has these columns: USER The user name part of the current user account. GRANTEE The ...