Debian Codegraph @

mysql-test/suite/sysschema/t/fn_ps_is_account_enabled.test

raw
1 -- source include/not_embedded.inc
2 # Tests for sys schema
3 # Verify the sys.ps_is_account_enabled() function perfoms as expected
4
5 # First test with the default "all enabled" for any random user
6 SELECT sys.ps_is_account_enabled('foo', 'bar');
7
8 # Now remove the wild card entry, and add some specific users to testx
9 DELETE FROM performance_schema.setup_actors;
10
11 INSERT INTO performance_schema.setup_actors VALUES
12 ('test', 'test', '%', 'YES', 'NO');
13
14 # Now the random account should not be enabled
15 SELECT sys.ps_is_account_enabled('foo', 'bar');
16
17 # But the specified one should
18 SELECT sys.ps_is_account_enabled('test', 'test');
19
20 --source ../include/ps_setup_actors_cleanup.inc