Good day,
show-grant outputs incorrect Sql format when access to the table is on selected fields only.
consider the ff. table
CREATE TABLE IF NOT EXISTS table3 ( SOrNum mediumint(9) unsigned NOT NULL auto_increment, SPNum mediumint(9) unsigned NOT NULL, DateCreated timestamp NOT NULL default CURRENT_TIMESTAMP, DateRelease timestamp NOT NULL default ‘0000-00-00 00:00:00’, ActualReleasedDate timestamp NULL default NULL, PckPrice decimal(10,2) NOT NULL default ‘0.00’, Status varchar(20) NOT NULL, PaymentStat varchar(20) NOT NULL default ‘Unpaid’, CusCode int(9) unsigned NOT NULL, SANumber mediumint(9) unsigned NOT NULL default ‘0’, SpecialInstruction varchar(500) default NULL, PRIMARY KEY (SOrNum)) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
if the user have only access to the following fields: DateCreated, PckPrice, PaymentStat, SANumber
the ouput of
pt-show-grants --user=root --ask-pass --only=user
is the ff. which is invalid
GRANT DateCreated, PaymentStat, PckPrice), SELECT (SANumber ON inventory.table3 TO ‘user’@‘%’;
Regards,