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; |