Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL), 11.3(EOL), 11.4
-
None
Description
tables_priv, columns_priv, procs_priv, proxies_priv all have a Timestamp field. However, it is set to 0 upon granting corresponding privileges (and in some cases in bootstrap upon creating default records, too).
create user u@localhost; |
create table t (a int); |
create procedure pr() begin end; |
grant select on test.t to u@localhost; |
grant insert (a) on test.t to u@localhost; |
grant execute on procedure test.pr to u@localhost; |
grant proxy on root@localhost to u@localhost; |
select `Timestamp`, `Table_name`, `Table_priv` from mysql.tables_priv where `Db` = 'test'; |
select `Timestamp`, `Column_name`, `Column_priv` from mysql.columns_priv where `Db` = 'test'; |
select `Timestamp`, `Routine_name`, `Proc_priv` from mysql.procs_priv where `Db` = 'test'; |
select `Timestamp`, `Proxied_user` from mysql.proxies_priv where User = 'u'; |
 |
drop user u@localhost; |
drop procedure pr; |
drop table t; |
10.4 87a5d16911bb94d383480fdd49e20876ed1400f2 |
select `Timestamp`, `Table_name`, `Table_priv` from mysql.tables_priv where `Db` = 'test'; |
Timestamp Table_name Table_priv |
0000-00-00 00:00:00 t Select |
select `Timestamp`, `Column_name`, `Column_priv` from mysql.columns_priv where `Db` = 'test'; |
Timestamp Column_name Column_priv |
0000-00-00 00:00:00 a Insert |
select `Timestamp`, `Routine_name`, `Proc_priv` from mysql.procs_priv where `Db` = 'test'; |
Timestamp Routine_name Proc_priv |
0000-00-00 00:00:00 pr Execute |
select `Timestamp`, `Proxied_user` from mysql.proxies_priv where User = 'u'; |
Timestamp Proxied_user |
0000-00-00 00:00:00 root
|