diff options
| author | Oleksandr Byelkin <sanja@mariadb.com> | 2019-11-06 12:35:19 +0100 |
|---|---|---|
| committer | Oleksandr Byelkin <sanja@mariadb.com> | 2020-02-05 17:22:26 +0100 |
| commit | fafb35ee517f309d9e507f6e3908caca5d8cd257 (patch) | |
| tree | 2b077c5fb367d221dd03b30365e66e9a8aa3b28f /mysql-test/suite/compat | |
| parent | b3ded21922fc684c3c1aeb4ad57161bc2fec5859 (diff) | |
| download | mariadb-git-fafb35ee517f309d9e507f6e3908caca5d8cd257.tar.gz | |
MDEV-20076: SHOW GRANTS does not quote role names properlybb-10.3-MDEV-20076
Quotes added to output.
Diffstat (limited to 'mysql-test/suite/compat')
| -rw-r--r-- | mysql-test/suite/compat/oracle/r/sp-package-security.result | 36 |
1 files changed, 18 insertions, 18 deletions
diff --git a/mysql-test/suite/compat/oracle/r/sp-package-security.result b/mysql-test/suite/compat/oracle/r/sp-package-security.result index 6cb580e0c46..c08b78cb8cf 100644 --- a/mysql-test/suite/compat/oracle/r/sp-package-security.result +++ b/mysql-test/suite/compat/oracle/r/sp-package-security.result @@ -132,15 +132,15 @@ END; $$ SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' -GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE "db1"."p1" TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" +GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE "db1"."p1" TO "u1"@"localhost" CALL p1; DROP PROCEDURE p1; SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" # # Now u1 can also CREATE, DROP its own package specifications # @@ -157,14 +157,14 @@ FUNCTION f1 RETURN TEXT; END latin1 latin1_swedish_ci latin1_swedish_ci SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' -GRANT EXECUTE, ALTER ROUTINE ON PACKAGE "db1"."pkg2" TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" +GRANT EXECUTE, ALTER ROUTINE ON PACKAGE "db1"."pkg2" TO "u1"@"localhost" DROP PACKAGE pkg2; SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" # # Now u1 can also CREATE, DROP package bodies and EXECUTE package body routines # @@ -184,9 +184,9 @@ FUNCTION f1 RETURN TEXT AS BEGIN RETURN 'This is pkg1.f1'; END; END latin1 latin1_swedish_ci latin1_swedish_ci SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' -GRANT EXECUTE, ALTER ROUTINE ON PACKAGE BODY "db1"."pkg1" TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" +GRANT EXECUTE, ALTER ROUTINE ON PACKAGE BODY "db1"."pkg1" TO "u1"@"localhost" CALL pkg1.p1; comment This is pkg1.p1 @@ -196,8 +196,8 @@ This is pkg1.f1 DROP PACKAGE BODY pkg1; SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" # # Now create a PACKAGE BODY by root. # u1 does not have EXECUTE access by default. @@ -232,9 +232,9 @@ u1@localhost SET sql_mode=ORACLE; SHOW GRANTS; Grants for u1@localhost -GRANT USAGE ON *.* TO 'u1'@'localhost' -GRANT SELECT, CREATE ROUTINE ON "db1".* TO 'u1'@'localhost' -GRANT EXECUTE ON PACKAGE BODY "db1"."pkg1" TO 'u1'@'localhost' +GRANT USAGE ON *.* TO "u1"@"localhost" +GRANT SELECT, CREATE ROUTINE ON "db1".* TO "u1"@"localhost" +GRANT EXECUTE ON PACKAGE BODY "db1"."pkg1" TO "u1"@"localhost" CALL pkg1.p1; comment This is pkg1.p1 |