8
8
drop procedure db1_secret.dummy;
10
10
create table t1 ( u varchar(64), i int );
11
12
create procedure stamp(i int)
12
13
insert into db1_secret.t1 values (user(), i);
13
14
show procedure status like 'stamp';
14
15
Db Name Type Definer Modified Created Security_type Comment
15
16
db1_secret stamp PROCEDURE root@localhost 0000-00-00 00:00:00 0000-00-00 00:00:00 DEFINER
17
23
show function status like 'db';
18
24
Db Name Type Definer Modified Created Security_type Comment
19
25
db1_secret db FUNCTION root@localhost 0000-00-00 00:00:00 0000-00-00 00:00:00 DEFINER
27
34
grant execute on procedure db1_secret.stamp to user1@'%';
28
35
grant execute on function db1_secret.db to user1@'%';
29
36
grant execute on procedure db1_secret.stamp to ''@'%';