1# Testing FR2 2Must have SESSION_VARIABLES_ADMIN with grant option 3SHOW GRANTS FOR root@localhost; 4Grants for root@localhost 5GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO `root`@`localhost` WITH GRANT OPTION 6GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ADMIN,BACKUP_ADMIN,BINLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,GROUP_REPLICATION_ADMIN,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PERSIST_RO_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_USER,ROLE_ADMIN,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER_ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `root`@`localhost` WITH GRANT OPTION 7GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION 8# Testing FR1 9CREATE USER wl12217@localhost; 10CREATE DATABASE wl12217; 11GRANT ALL PRIVILEGES ON wl12217.* TO wl12217@localhost; 12# Must work 13GRANT SESSION_VARIABLES_ADMIN ON *.* TO wl12217@localhost; 14# Must work again 15GRANT SESSION_VARIABLES_ADMIN ON *.* TO wl12217@localhost; 16# Must fail 17GRANT SESSION_VARIABLES_ADMIN ON mysql.* TO wl12217@localhost; 18ERROR HY000: Illegal privilege level specified for SESSION_VARIABLES_ADMIN 19# Cleanup 20DROP DATABASE wl12217; 21DROP USER wl12217@localhost; 22# Testing FR3, FR4 23CREATE USER wl12217@localhost; 24CREATE DATABASE wl12217; 25GRANT ALL PRIVILEGES ON wl12217.* TO wl12217@localhost; 26# Switch to wl12217@localhost 27# Must fail 28SET SESSION binlog_direct_non_transactional_updates = DEFAULT; 29ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 30SET SESSION binlog_format = DEFAULT; 31ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 32SET SESSION binlog_row_image = DEFAULT; 33ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 34SET SESSION binlog_row_value_options = DEFAULT; 35ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 36SET SESSION binlog_rows_query_log_events = DEFAULT; 37ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 38SET SESSION bulk_insert_buffer_size = DEFAULT; 39ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 40SET SESSION character_set_database = DEFAULT; 41ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 42SET SESSION character_set_filesystem = DEFAULT; 43ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 44SET SESSION pseudo_slave_mode = DEFAULT; 45ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN or REPLICATION_APPLIER privilege(s) for this operation 46SET SESSION pseudo_thread_id = DEFAULT; 47ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 48SET SESSION transaction_write_set_extraction = DEFAULT; 49ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 50SET SESSION histogram_generation_max_mem_size = DEFAULT; 51ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 52SET SESSION sql_log_off = DEFAULT; 53ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 54SET SESSION original_commit_timestamp = DEFAULT; 55ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN, SESSION_VARIABLES_ADMIN or REPLICATION_APPLIER privilege(s) for this operation 56SET SESSION sql_log_bin = DEFAULT; 57ERROR 42000: Access denied; you need (at least one of) the SUPER, SYSTEM_VARIABLES_ADMIN or SESSION_VARIABLES_ADMIN privilege(s) for this operation 58# Back to default connection 59GRANT SESSION_VARIABLES_ADMIN ON *.* TO wl12217@localhost; 60# Back to wl12217@localhost 61# Must pass 62SET SESSION auto_increment_increment = DEFAULT; 63SET SESSION auto_increment_offset = DEFAULT; 64SET SESSION binlog_direct_non_transactional_updates = DEFAULT; 65SET SESSION binlog_format = DEFAULT; 66SET SESSION binlog_row_image = DEFAULT; 67SET SESSION binlog_row_value_options = DEFAULT; 68SET SESSION binlog_rows_query_log_events = DEFAULT; 69SET SESSION bulk_insert_buffer_size = DEFAULT; 70SET SESSION character_set_database = DEFAULT; 71Warnings: 72Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release. 73SET SESSION character_set_filesystem = DEFAULT; 74SET SESSION collation_database = DEFAULT; 75Warnings: 76Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 77SET SESSION pseudo_slave_mode = DEFAULT; 78Warnings: 79Warning 1231 'pseudo_slave_mode' change was ineffective. 80SET SESSION pseudo_thread_id = DEFAULT; 81SET SESSION transaction_write_set_extraction = DEFAULT; 82SET SESSION histogram_generation_max_mem_size = DEFAULT; 83SET SESSION sql_log_off = DEFAULT; 84SET SESSION original_commit_timestamp = DEFAULT; 85SET SESSION default_collation_for_utf8mb4 = DEFAULT; 86Warnings: 87Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release. 88SET SESSION explicit_defaults_for_timestamp = DEFAULT; 89SET SESSION sql_log_bin = DEFAULT; 90SET SESSION rbr_exec_mode = DEFAULT; 91# Back to default connection 92# Cleanup 93DROP DATABASE wl12217; 94DROP USER wl12217@localhost; 95# Testing FR5 96CREATE USER wl12217@localhost; 97CREATE DATABASE wl12217; 98GRANT ALL PRIVILEGES ON wl12217.* TO wl12217@localhost; 99GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO wl12217@localhost; 100# Switch to wl12217@localhost 101# Must pass 102SET SESSION auto_increment_increment = DEFAULT; 103SET SESSION auto_increment_offset = DEFAULT; 104SET SESSION binlog_direct_non_transactional_updates = DEFAULT; 105SET SESSION binlog_format = DEFAULT; 106SET SESSION binlog_row_image = DEFAULT; 107SET SESSION binlog_row_value_options = DEFAULT; 108SET SESSION binlog_rows_query_log_events = DEFAULT; 109SET SESSION bulk_insert_buffer_size = DEFAULT; 110SET SESSION character_set_database = DEFAULT; 111Warnings: 112Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release. 113SET SESSION character_set_filesystem = DEFAULT; 114SET SESSION collation_database = DEFAULT; 115Warnings: 116Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 117SET SESSION pseudo_slave_mode = DEFAULT; 118Warnings: 119Warning 1231 'pseudo_slave_mode' change was ineffective. 120SET SESSION pseudo_thread_id = DEFAULT; 121SET SESSION transaction_write_set_extraction = DEFAULT; 122SET SESSION histogram_generation_max_mem_size = DEFAULT; 123SET SESSION sql_log_off = DEFAULT; 124SET SESSION original_commit_timestamp = DEFAULT; 125SET SESSION default_collation_for_utf8mb4 = DEFAULT; 126Warnings: 127Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release. 128SET SESSION explicit_defaults_for_timestamp = DEFAULT; 129SET SESSION sql_log_bin = DEFAULT; 130SET SESSION rbr_exec_mode = DEFAULT; 131# Back to default connection 132# Cleanup 133DROP DATABASE wl12217; 134DROP USER wl12217@localhost; 135# Testing FR6 136CREATE USER wl12217@localhost; 137CREATE DATABASE wl12217; 138GRANT ALL PRIVILEGES ON wl12217.* TO wl12217@localhost; 139GRANT SUPER ON *.* TO wl12217@localhost; 140Warnings: 141Warning 1287 The SUPER privilege identifier is deprecated 142# Switch to wl12217@localhost 143# Must pass 144SET SESSION auto_increment_increment = DEFAULT; 145SET SESSION auto_increment_offset = DEFAULT; 146SET SESSION binlog_direct_non_transactional_updates = DEFAULT; 147SET SESSION binlog_format = DEFAULT; 148SET SESSION binlog_row_image = DEFAULT; 149SET SESSION binlog_row_value_options = DEFAULT; 150SET SESSION binlog_rows_query_log_events = DEFAULT; 151SET SESSION bulk_insert_buffer_size = DEFAULT; 152SET SESSION character_set_database = DEFAULT; 153Warnings: 154Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release. 155SET SESSION character_set_filesystem = DEFAULT; 156SET SESSION collation_database = DEFAULT; 157Warnings: 158Warning 1681 Updating 'collation_database' is deprecated. It will be made read-only in a future release. 159SET SESSION pseudo_slave_mode = DEFAULT; 160Warnings: 161Warning 1231 'pseudo_slave_mode' change was ineffective. 162SET SESSION pseudo_thread_id = DEFAULT; 163SET SESSION transaction_write_set_extraction = DEFAULT; 164SET SESSION histogram_generation_max_mem_size = DEFAULT; 165SET SESSION sql_log_off = DEFAULT; 166SET SESSION original_commit_timestamp = DEFAULT; 167SET SESSION default_collation_for_utf8mb4 = DEFAULT; 168Warnings: 169Warning 1681 Updating 'default_collation_for_utf8mb4' is deprecated. It will be made read-only in a future release. 170SET SESSION explicit_defaults_for_timestamp = DEFAULT; 171SET SESSION sql_log_bin = DEFAULT; 172SET SESSION rbr_exec_mode = DEFAULT; 173# Back to default connection 174# Cleanup 175DROP DATABASE wl12217; 176DROP USER wl12217@localhost; 177# Testing FR7 178# Must have SESSION_VARIABLES_ADMIN 179SHOW GRANTS for "mysql.session"@localhost; 180Grants for mysql.session@localhost 181GRANT SHUTDOWN, SUPER ON *.* TO `mysql.session`@`localhost` 182GRANT BACKUP_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,PERSIST_RO_VARIABLES_ADMIN,SESSION_VARIABLES_ADMIN,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN ON *.* TO `mysql.session`@`localhost` 183GRANT SELECT ON `performance_schema`.* TO `mysql.session`@`localhost` 184GRANT SELECT ON `mysql`.`user` TO `mysql.session`@`localhost` 185# 186# End of 8.0 tests 187# 188