Debian Codegraph @

mysql-test/suite/x/t/roles_xplugin.test

raw
1 --source include/xplugin_preamble.inc
2 --source include/xplugin_create_user.inc
3 ## Test starts here
4 --write_file $MYSQL_TMP_DIR/roles_test.xpl
5 ## Test data
6 -->sql
7
8 DROP ROLE IF EXISTS r1, r2, u1@localhost, u2;
9 CREATE USER u1@localhost IDENTIFIED BY 'foo', u2;
10 CREATE ROLE r1,r2;
11 GRANT r1, r2 TO u1@localhost, u2;
12 GRANT ALL ON test.* TO r2;
13 ALTER USER u1@localhost DEFAULT ROLE r1,r2;
14 SELECT CURRENT_ROLE();
15 SET ROLE ALL;
16 SET ROLE DEFAULT;
17 SET ROLE NONE;
18 DROP ROLE r1,r2;
19 DROP USER u1@localhost, u2;
20
21 -->endsql
22 EOF
23
24 --exec $MYSQLXTEST -ux_root --password='' --file=$MYSQL_TMP_DIR/roles_test.xpl 2>&1
25
26 ## Cleanup
27 --source ../include/xplugin_cleanup.inc