GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

pt-show-grant

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-show-grant

    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,

  • #2
    Please file a bug report.

    Comment

    Working...
    X