Debian Codegraph @

mysql-test/suite/information_schema/include/roles_i_s_test.inc

raw
1
2 --echo # Connect as $USER_NAME
3 connect(con1, localhost, $USER_NAME, foo, test);
4
5 --echo # With the roles activated during connection.
6 eval SELECT * FROM INFORMATION_SCHEMA.$TEST_TABLE $ORDER_BY;
7 SELECT CURRENT_ROLE();
8 SHOW GRANTS;
9
10 --echo # Enable roles;
11 eval SET ROLE $ROLE_LIST;
12 eval SELECT * FROM INFORMATION_SCHEMA.$TEST_TABLE $ORDER_BY;
13 SELECT CURRENT_ROLE();
14 SHOW GRANTS;
15
16 --echo Disconnect $USER_NAME
17 disconnect con1;
18 connection default;