MDEV-9077 sys schema . use 'mariadb.sys'@'localhost' as definer for viewsbb-10.6-MDEV-9077

28 files changed, 28 insertions, 28 deletions

diff --git a/scripts/sys_schema/procedures/create_synonym_db.sql b/scripts/sys_schema/procedures/create_synonym_db.sql
index 4f6a8efb223..703ec9bff3b 100644
--- a/scripts/sys_schema/procedures/create_synonym_db.sql
+++ b/scripts/sys_schema/procedures/create_synonym_db.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS create_synonym_db;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE create_synonym_db (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE create_synonym_db (
         IN in_db_name VARCHAR(64), 
         IN in_synonym VARCHAR(64)
     )
diff --git a/scripts/sys_schema/procedures/diagnostics.sql b/scripts/sys_schema/procedures/diagnostics.sql
index 8cccdb68233..2e79c5c1c2a 100644
--- a/scripts/sys_schema/procedures/diagnostics.sql
+++ b/scripts/sys_schema/procedures/diagnostics.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS diagnostics;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE diagnostics (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE diagnostics (
         IN in_max_runtime int unsigned, IN in_interval int unsigned,
         IN in_auto_config enum ('current', 'medium', 'full')
     )
diff --git a/scripts/sys_schema/procedures/execute_prepared_stmt.sql b/scripts/sys_schema/procedures/execute_prepared_stmt.sql
index b77732b5487..8e975b909c2 100644
--- a/scripts/sys_schema/procedures/execute_prepared_stmt.sql
+++ b/scripts/sys_schema/procedures/execute_prepared_stmt.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS execute_prepared_stmt;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE execute_prepared_stmt (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE execute_prepared_stmt (
         IN in_query longtext CHARACTER SET UTF8
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_disable_background_threads.sql b/scripts/sys_schema/procedures/ps_setup_disable_background_threads.sql
index 7d0758a4747..0c316bc78b8 100644
--- a/scripts/sys_schema/procedures/ps_setup_disable_background_threads.sql
+++ b/scripts/sys_schema/procedures/ps_setup_disable_background_threads.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_disable_background_threads;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_disable_background_threads ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_disable_background_threads ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_setup_disable_consumer.sql b/scripts/sys_schema/procedures/ps_setup_disable_consumer.sql
index bf0c558186f..bdebd62e419 100644
--- a/scripts/sys_schema/procedures/ps_setup_disable_consumer.sql
+++ b/scripts/sys_schema/procedures/ps_setup_disable_consumer.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_disable_consumer;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_disable_consumer (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_disable_consumer (
         IN consumer VARCHAR(128)
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_disable_instrument.sql b/scripts/sys_schema/procedures/ps_setup_disable_instrument.sql
index 5132e33740c..14fe4d86b1d 100644
--- a/scripts/sys_schema/procedures/ps_setup_disable_instrument.sql
+++ b/scripts/sys_schema/procedures/ps_setup_disable_instrument.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_disable_instrument;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_disable_instrument (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_disable_instrument (
         IN in_pattern VARCHAR(128)
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_disable_thread.sql b/scripts/sys_schema/procedures/ps_setup_disable_thread.sql
index 9141d387540..fe0bb86275f 100644
--- a/scripts/sys_schema/procedures/ps_setup_disable_thread.sql
+++ b/scripts/sys_schema/procedures/ps_setup_disable_thread.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_disable_thread;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_disable_thread (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_disable_thread (
         IN in_connection_id BIGINT
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_enable_background_threads.sql b/scripts/sys_schema/procedures/ps_setup_enable_background_threads.sql
index a5edee09810..ddca06b1287 100644
--- a/scripts/sys_schema/procedures/ps_setup_enable_background_threads.sql
+++ b/scripts/sys_schema/procedures/ps_setup_enable_background_threads.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_enable_background_threads;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_enable_background_threads ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_enable_background_threads ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_setup_enable_consumer.sql b/scripts/sys_schema/procedures/ps_setup_enable_consumer.sql
index d728285a6a2..66138604595 100644
--- a/scripts/sys_schema/procedures/ps_setup_enable_consumer.sql
+++ b/scripts/sys_schema/procedures/ps_setup_enable_consumer.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_enable_consumer;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_enable_consumer (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_enable_consumer (
         IN consumer VARCHAR(128)
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_enable_instrument.sql b/scripts/sys_schema/procedures/ps_setup_enable_instrument.sql
index 6be9f343a64..964307de45a 100644
--- a/scripts/sys_schema/procedures/ps_setup_enable_instrument.sql
+++ b/scripts/sys_schema/procedures/ps_setup_enable_instrument.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_enable_instrument;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_enable_instrument (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_enable_instrument (
         IN in_pattern VARCHAR(128)
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_enable_thread.sql b/scripts/sys_schema/procedures/ps_setup_enable_thread.sql
index f03f7bd3ed3..15385fc8a3e 100644
--- a/scripts/sys_schema/procedures/ps_setup_enable_thread.sql
+++ b/scripts/sys_schema/procedures/ps_setup_enable_thread.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_enable_thread;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_enable_thread (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_enable_thread (
         IN in_connection_id BIGINT
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_reload_saved.sql b/scripts/sys_schema/procedures/ps_setup_reload_saved.sql
index 1ffde684113..38d463b1a4c 100644
--- a/scripts/sys_schema/procedures/ps_setup_reload_saved.sql
+++ b/scripts/sys_schema/procedures/ps_setup_reload_saved.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_reload_saved;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_reload_saved ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_reload_saved ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_setup_reset_to_default.sql b/scripts/sys_schema/procedures/ps_setup_reset_to_default.sql
index 80804206e2e..b626fae82fd 100644
--- a/scripts/sys_schema/procedures/ps_setup_reset_to_default.sql
+++ b/scripts/sys_schema/procedures/ps_setup_reset_to_default.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_reset_to_default;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_reset_to_default (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_reset_to_default (
        IN in_verbose BOOLEAN
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_reset_to_default_57.sql b/scripts/sys_schema/procedures/ps_setup_reset_to_default_57.sql
index 7fb6b28ba11..8d3b2eecf71 100644
--- a/scripts/sys_schema/procedures/ps_setup_reset_to_default_57.sql
+++ b/scripts/sys_schema/procedures/ps_setup_reset_to_default_57.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_reset_to_default;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_reset_to_default (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_reset_to_default (
        IN in_verbose BOOLEAN
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_save.sql b/scripts/sys_schema/procedures/ps_setup_save.sql
index 97603c758a0..a5a2197e935 100644
--- a/scripts/sys_schema/procedures/ps_setup_save.sql
+++ b/scripts/sys_schema/procedures/ps_setup_save.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_save;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_save (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_save (
         IN in_timeout INT
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/ps_setup_show_disabled.sql b/scripts/sys_schema/procedures/ps_setup_show_disabled.sql
index 3148c5a5b6e..82c69840566 100644
--- a/scripts/sys_schema/procedures/ps_setup_show_disabled.sql
+++ b/scripts/sys_schema/procedures/ps_setup_show_disabled.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_show_disabled;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_disabled (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_show_disabled (
         IN in_show_instruments BOOLEAN,
         IN in_show_threads BOOLEAN
     )
diff --git a/scripts/sys_schema/procedures/ps_setup_show_disabled_consumers.sql b/scripts/sys_schema/procedures/ps_setup_show_disabled_consumers.sql
index b21ba2bcea7..4c913efdc0e 100644
--- a/scripts/sys_schema/procedures/ps_setup_show_disabled_consumers.sql
+++ b/scripts/sys_schema/procedures/ps_setup_show_disabled_consumers.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_show_disabled_consumers;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_disabled_consumers ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_show_disabled_consumers ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_setup_show_disabled_instruments.sql b/scripts/sys_schema/procedures/ps_setup_show_disabled_instruments.sql
index e893bb635f5..45fe7c083df 100644
--- a/scripts/sys_schema/procedures/ps_setup_show_disabled_instruments.sql
+++ b/scripts/sys_schema/procedures/ps_setup_show_disabled_instruments.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_show_disabled_instruments;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_disabled_instruments ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_show_disabled_instruments ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_setup_show_enabled.sql b/scripts/sys_schema/procedures/ps_setup_show_enabled.sql
index 7b2c2644358..8e7c0506677 100644
--- a/scripts/sys_schema/procedures/ps_setup_show_enabled.sql
+++ b/scripts/sys_schema/procedures/ps_setup_show_enabled.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_show_enabled;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_enabled (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_show_enabled (
         IN in_show_instruments BOOLEAN,
         IN in_show_threads BOOLEAN
     )
diff --git a/scripts/sys_schema/procedures/ps_setup_show_enabled_consumers.sql b/scripts/sys_schema/procedures/ps_setup_show_enabled_consumers.sql
index f8e5ddeed6e..57ec2b751b5 100644
--- a/scripts/sys_schema/procedures/ps_setup_show_enabled_consumers.sql
+++ b/scripts/sys_schema/procedures/ps_setup_show_enabled_consumers.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_show_enabled_consumers;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_enabled_consumers ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_show_enabled_consumers ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_setup_show_enabled_instruments.sql b/scripts/sys_schema/procedures/ps_setup_show_enabled_instruments.sql
index d26bd680805..d8cfb108995 100644
--- a/scripts/sys_schema/procedures/ps_setup_show_enabled_instruments.sql
+++ b/scripts/sys_schema/procedures/ps_setup_show_enabled_instruments.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_setup_show_enabled_instruments;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_setup_show_enabled_instruments ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_setup_show_enabled_instruments ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_statement_avg_latency_histogram.sql b/scripts/sys_schema/procedures/ps_statement_avg_latency_histogram.sql
index f808de31a3a..e57cbc1d452 100644
--- a/scripts/sys_schema/procedures/ps_statement_avg_latency_histogram.sql
+++ b/scripts/sys_schema/procedures/ps_statement_avg_latency_histogram.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_statement_avg_latency_histogram;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_statement_avg_latency_histogram ()
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_statement_avg_latency_histogram ()
     COMMENT '
              Description
              -----------
diff --git a/scripts/sys_schema/procedures/ps_trace_statement_digest.sql b/scripts/sys_schema/procedures/ps_trace_statement_digest.sql
index 57cf8df32cb..f9bb4d3b09e 100644
--- a/scripts/sys_schema/procedures/ps_trace_statement_digest.sql
+++ b/scripts/sys_schema/procedures/ps_trace_statement_digest.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_trace_statement_digest;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_trace_statement_digest (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_trace_statement_digest (
         IN in_digest VARCHAR(32),
         IN in_runtime INT, 
         IN in_interval DECIMAL(2,2),
diff --git a/scripts/sys_schema/procedures/ps_trace_thread.sql b/scripts/sys_schema/procedures/ps_trace_thread.sql
index 35699a9e4c8..6e5666c2dea 100644
--- a/scripts/sys_schema/procedures/ps_trace_thread.sql
+++ b/scripts/sys_schema/procedures/ps_trace_thread.sql
@@ -16,7 +16,7 @@
 DROP PROCEDURE IF EXISTS ps_trace_thread;
 
 DELIMITER $$
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_trace_thread (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_trace_thread (
         IN in_thread_id BIGINT UNSIGNED,
         IN in_outfile VARCHAR(255),
         IN in_max_runtime DECIMAL(20,2),
diff --git a/scripts/sys_schema/procedures/ps_trace_thread_57.sql b/scripts/sys_schema/procedures/ps_trace_thread_57.sql
index 313d51854a3..9aae53ba161 100644
--- a/scripts/sys_schema/procedures/ps_trace_thread_57.sql
+++ b/scripts/sys_schema/procedures/ps_trace_thread_57.sql
@@ -16,7 +16,7 @@
 DROP PROCEDURE IF EXISTS ps_trace_thread;
 
 DELIMITER $$
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_trace_thread (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_trace_thread (
         IN in_thread_id BIGINT UNSIGNED,
         IN in_outfile VARCHAR(255),
         IN in_max_runtime DECIMAL(20,2),
diff --git a/scripts/sys_schema/procedures/ps_truncate_all_tables.sql b/scripts/sys_schema/procedures/ps_truncate_all_tables.sql
index cfd4fee8209..42d904f507c 100644
--- a/scripts/sys_schema/procedures/ps_truncate_all_tables.sql
+++ b/scripts/sys_schema/procedures/ps_truncate_all_tables.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS ps_truncate_all_tables;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE ps_truncate_all_tables (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE ps_truncate_all_tables (
         IN in_verbose BOOLEAN
     )
     COMMENT '
diff --git a/scripts/sys_schema/procedures/statement_performance_analyzer.sql b/scripts/sys_schema/procedures/statement_performance_analyzer.sql
index fcb5af1f52e..f98596ef913 100644
--- a/scripts/sys_schema/procedures/statement_performance_analyzer.sql
+++ b/scripts/sys_schema/procedures/statement_performance_analyzer.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS statement_performance_analyzer;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE statement_performance_analyzer (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE statement_performance_analyzer (
         IN in_action ENUM('snapshot', 'overall', 'delta', 'create_table', 'create_tmp', 'save', 'cleanup'),
         IN in_table VARCHAR(129),
         IN in_views SET ('with_runtimes_in_95th_percentile', 'analysis', 'with_errors_or_warnings', 'with_full_table_scans', 'with_sorting', 'with_temp_tables', 'custom')
diff --git a/scripts/sys_schema/procedures/table_exists.sql b/scripts/sys_schema/procedures/table_exists.sql
index 704edea8030..6f487f2f341 100644
--- a/scripts/sys_schema/procedures/table_exists.sql
+++ b/scripts/sys_schema/procedures/table_exists.sql
@@ -17,7 +17,7 @@ DROP PROCEDURE IF EXISTS table_exists;
 
 DELIMITER $$
 
-CREATE DEFINER='root'@'localhost' PROCEDURE table_exists (
+CREATE DEFINER='mariadb.sys'@'localhost' PROCEDURE table_exists (
         IN in_db VARCHAR(64), IN in_table VARCHAR(64),
         OUT out_exists ENUM('', 'BASE TABLE', 'VIEW', 'TEMPORARY')
     )