diff options
Diffstat (limited to 'storage/connect/mysql-test/connect/r/grant.result')
-rw-r--r-- | storage/connect/mysql-test/connect/r/grant.result | 59 |
1 files changed, 59 insertions, 0 deletions
diff --git a/storage/connect/mysql-test/connect/r/grant.result b/storage/connect/mysql-test/connect/r/grant.result index 681442724e5..eeecfde9df4 100644 --- a/storage/connect/mysql-test/connect/r/grant.result +++ b/storage/connect/mysql-test/connect/r/grant.result @@ -4,6 +4,8 @@ set sql_mode=""; # GRANT ALL PRIVILEGES ON *.* TO user@localhost; REVOKE FILE ON *.* FROM user@localhost; +connect user,localhost,user,,; +connection user; SELECT user(); user() user@localhost @@ -14,6 +16,7 @@ ftype CHAR(4) NOT NULL, size DOUBLE(12,0) NOT NULL flag=5 ) ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='*.*'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost @@ -25,7 +28,9 @@ size DOUBLE(12,0) NOT NULL flag=5 ) ENGINE=CONNECT TABLE_TYPE=DIR FILE_NAME='*.*'; SELECT fname, ftype, size FROM t1 WHERE size>0; fname ftype size +db .opt 65 t1 .frm 1081 +connection user; SELECT user(); user() user@localhost @@ -44,10 +49,12 @@ ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for CREATE VIEW v1 AS SELECT * FROM t1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation # Testing a VIEW created with FILE privileges but accessed with no FILE +connection default; SELECT user(); user() root@localhost CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT * FROM t1; +connection user; SELECT user(); user() user@localhost @@ -59,6 +66,8 @@ UPDATE v1 SET path=123; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation DELETE FROM v1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +disconnect user; +connection default; SELECT user(); user() root@localhost @@ -74,6 +83,8 @@ DROP USER user@localhost; CREATE USER user@localhost; GRANT ALL PRIVILEGES ON *.* TO user@localhost; REVOKE FILE ON *.* FROM user@localhost; +connect user,localhost,user,,; +connection user; SELECT user(); user() user@localhost @@ -102,11 +113,13 @@ DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=BIN FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=BIN FILE_NAME='t1.EXT'; INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost @@ -129,10 +142,12 @@ ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for CREATE VIEW v1 AS SELECT * FROM t1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation # Testing a VIEW created with FILE privileges but accessed with no FILE +connection default; SELECT user(); user() root@localhost CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT * FROM t1; +connection user; SELECT user(); user() user@localhost @@ -144,6 +159,7 @@ UPDATE v1 SET a=123; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation DELETE FROM v1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost @@ -153,12 +169,15 @@ CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=BIN; Warnings: Warning 1105 No file name. Table will use t1.bin INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost ALTER TABLE t1 FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; DROP TABLE t1; +disconnect user; DROP USER user@localhost; # # End of grant.inc @@ -169,6 +188,8 @@ DROP USER user@localhost; CREATE USER user@localhost; GRANT ALL PRIVILEGES ON *.* TO user@localhost; REVOKE FILE ON *.* FROM user@localhost; +connect user,localhost,user,,; +connection user; SELECT user(); user() user@localhost @@ -197,11 +218,13 @@ DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV FILE_NAME='t1.EXT'; INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost @@ -224,10 +247,12 @@ ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for CREATE VIEW v1 AS SELECT * FROM t1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation # Testing a VIEW created with FILE privileges but accessed with no FILE +connection default; SELECT user(); user() root@localhost CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT * FROM t1; +connection user; SELECT user(); user() user@localhost @@ -239,6 +264,7 @@ UPDATE v1 SET a=123; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation DELETE FROM v1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost @@ -248,12 +274,15 @@ CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=CSV; Warnings: Warning 1105 No file name. Table will use t1.csv INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost ALTER TABLE t1 FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; DROP TABLE t1; +disconnect user; DROP USER user@localhost; # # End of grant.inc @@ -264,6 +293,8 @@ DROP USER user@localhost; CREATE USER user@localhost; GRANT ALL PRIVILEGES ON *.* TO user@localhost; REVOKE FILE ON *.* FROM user@localhost; +connect user,localhost,user,,; +connection user; SELECT user(); user() user@localhost @@ -292,11 +323,13 @@ DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF FILE_NAME='t1.EXT'; INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost @@ -319,10 +352,12 @@ ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for CREATE VIEW v1 AS SELECT * FROM t1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation # Testing a VIEW created with FILE privileges but accessed with no FILE +connection default; SELECT user(); user() root@localhost CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT * FROM t1; +connection user; SELECT user(); user() user@localhost @@ -334,6 +369,7 @@ UPDATE v1 SET a=123; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation DELETE FROM v1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost @@ -343,12 +379,15 @@ CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=DBF; Warnings: Warning 1105 No file name. Table will use t1.dbf INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost ALTER TABLE t1 FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; DROP TABLE t1; +disconnect user; DROP USER user@localhost; # # End of grant.inc @@ -359,6 +398,8 @@ DROP USER user@localhost; CREATE USER user@localhost; GRANT ALL PRIVILEGES ON *.* TO user@localhost; REVOKE FILE ON *.* FROM user@localhost; +connect user,localhost,user,,; +connection user; SELECT user(); user() user@localhost @@ -387,11 +428,13 @@ DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='t1.EXT'; INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost @@ -414,10 +457,12 @@ ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for CREATE VIEW v1 AS SELECT * FROM t1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation # Testing a VIEW created with FILE privileges but accessed with no FILE +connection default; SELECT user(); user() root@localhost CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT * FROM t1; +connection user; SELECT user(); user() user@localhost @@ -429,6 +474,7 @@ UPDATE v1 SET a=123; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation DELETE FROM v1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost @@ -438,12 +484,15 @@ CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=FIX; Warnings: Warning 1105 No file name. Table will use t1.fix INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost ALTER TABLE t1 FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; DROP TABLE t1; +disconnect user; DROP USER user@localhost; # # End of grant.inc @@ -454,6 +503,8 @@ DROP USER user@localhost; CREATE USER user@localhost; GRANT ALL PRIVILEGES ON *.* TO user@localhost; REVOKE FILE ON *.* FROM user@localhost; +connect user,localhost,user,,; +connection user; SELECT user(); user() user@localhost @@ -482,11 +533,13 @@ DROP VIEW v1; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=VEC MAX_ROWS=100 FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=VEC MAX_ROWS=100 FILE_NAME='t1.EXT'; INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost @@ -509,10 +562,12 @@ ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for CREATE VIEW v1 AS SELECT * FROM t1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation # Testing a VIEW created with FILE privileges but accessed with no FILE +connection default; SELECT user(); user() root@localhost CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT * FROM t1; +connection user; SELECT user(); user() user@localhost @@ -524,6 +579,7 @@ UPDATE v1 SET a=123; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation DELETE FROM v1; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; SELECT user(); user() root@localhost @@ -533,12 +589,15 @@ CREATE TABLE t1 (a INT NOT NULL) ENGINE=CONNECT TABLE_TYPE=VEC MAX_ROWS=100; Warnings: Warning 1105 No file name. Table will use t1.vec INSERT INTO t1 VALUES (10); +connection user; SELECT user(); user() user@localhost ALTER TABLE t1 FILE_NAME='t1.EXT'; ERROR 42000: Access denied; you need (at least one of) the FILE privilege(s) for this operation +connection default; DROP TABLE t1; +disconnect user; DROP USER user@localhost; # # End of grant.inc |