Debian Codegraph @

mysql-test/suite/roles/acl_statistics.result

raw
1 SHOW STATUS LIKE 'Acl%';
2 Variable_name Value
3 Acl_column_grants 0
4 Acl_database_grants 0
5 Acl_function_grants 0
6 Acl_procedure_grants 0
7 Acl_package_spec_grants 0
8 Acl_package_body_grants 0
9 Acl_proxy_users 4
10 Acl_role_grants 0
11 Acl_roles 0
12 Acl_table_grants 1
13 Acl_users 5
14 SELECT count(*) COLUMN_GRANTS from mysql.columns_priv;
15 COLUMN_GRANTS
16 0
17 SELECT count(*) DATABASE_GRANTS from mysql.db;
18 DATABASE_GRANTS
19 0
20 SELECT count(*) FUNCTION_GRANTS from mysql.procs_priv where routine_type='FUNCTION';
21 FUNCTION_GRANTS
22 0
23 SELECT count(*) PROCEDURE_GRANTS from mysql.procs_priv where routine_type='PROCEDURE';
24 PROCEDURE_GRANTS
25 0
26 SELECT count(*) PROXY_USERS from mysql.proxies_priv;
27 PROXY_USERS
28 4
29 SELECT count(*) ROLE_GRANTS from mysql.roles_mapping;
30 ROLE_GRANTS
31 0
32 SELECT count(*) ROLES from mysql.user where is_role='Y';
33 ROLES
34 0
35 SELECT count(*) TABLE_GRANTS from mysql.tables_priv;
36 TABLE_GRANTS
37 1
38 SELECT count(*) USERS from mysql.user where is_role='N';
39 USERS
40 5
41 CREATE USER u1;
42 CREATE ROLE r1;
43 CREATE ROLE r2;
44 GRANT PROXY ON root TO u1;
45 GRANT SELECT ON *.* to u1;
46 GRANT SELECT ON *.* to r1;
47 GRANT DELETE ON mysql.* to u1;
48 GRANT DELETE ON mysql.* to r1;
49 GRANT INSERT ON mysql.user to u1;
50 GRANT INSERT ON mysql.user to r1;
51 GRANT UPDATE (host) ON mysql.user to u1;
52 GRANT UPDATE (host) ON mysql.user to r1;
53 GRANT r1 to u1;
54 GRANT r2 to r1;
55 create procedure mysql.test_proc (OUT param1 INT)
56 begin
57 select COUNT(*) into param1 from mysql.roles_mapping;
58 end|
59 GRANT EXECUTE ON PROCEDURE mysql.test_proc TO r1;
60 GRANT EXECUTE ON PROCEDURE mysql.test_proc TO u1;
61 CREATE FUNCTION mysql.test_func (param INT) RETURNS INT
62 RETURN (SELECT COUNT(*) FROM mysql.user);
63 GRANT EXECUTE ON FUNCTION mysql.test_func TO r1;
64 GRANT EXECUTE ON FUNCTION mysql.test_func TO u1;
65 GRANT EXECUTE ON FUNCTION mysql.test_func TO r2;
66 SHOW STATUS LIKE 'Acl%';
67 Variable_name Value
68 Acl_column_grants 2
69 Acl_database_grants 2
70 Acl_function_grants 3
71 Acl_procedure_grants 2
72 Acl_package_spec_grants 0
73 Acl_package_body_grants 0
74 Acl_proxy_users 5
75 Acl_role_grants 4
76 Acl_roles 2
77 Acl_table_grants 3
78 Acl_users 6
79 SELECT count(*) COLUMN_GRANTS from mysql.columns_priv;
80 COLUMN_GRANTS
81 2
82 SELECT count(*) DATABASE_GRANTS from mysql.db;
83 DATABASE_GRANTS
84 2
85 SELECT count(*) FUNCTION_GRANTS from mysql.procs_priv where routine_type='FUNCTION';
86 FUNCTION_GRANTS
87 3
88 SELECT count(*) PROCEDURE_GRANTS from mysql.procs_priv where routine_type='PROCEDURE';
89 PROCEDURE_GRANTS
90 2
91 SELECT count(*) PROXY_USERS from mysql.proxies_priv;
92 PROXY_USERS
93 5
94 SELECT count(*) ROLE_GRANTS from mysql.roles_mapping;
95 ROLE_GRANTS
96 4
97 SELECT count(*) ROLES from mysql.user where is_role='Y';
98 ROLES
99 2
100 SELECT count(*) TABLE_GRANTS from mysql.tables_priv;
101 TABLE_GRANTS
102 3
103 SELECT count(*) USERS from mysql.user where is_role='N';
104 USERS
105 6
106 DROP PROCEDURE mysql.test_proc;
107 DROP FUNCTION mysql.test_func;
108 DROP ROLE r2;
109 DROP ROLE r1;
110 DROP USER u1;