Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5096

PS 8.0 Page for extended show grants is outdated

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: 8.0
    • Fix Version/s: 8.0.13-4
    • Component/s: Documentation
    • Labels:
      None

      Description

      This page for PS 8.0 is wrong:
      https://www.percona.com/doc/percona-server/8.0/management/extended_show_grants.html

      In this ticket the command has been changed: https://jira.percona.com/browse/PS-281

      So the new command is "SHOW EFFECTIVE GRANTS;"
      If you use just "SHOW GRANTS;" like in the last example on the page you will get upstream behaviour.

      Here's how it looks on the server:

      mysql> SHOW GRANTS;
      +---------------------------------------------+
      | Grants for grantee@localhost                |
      +---------------------------------------------+
      | GRANT USAGE ON *.* TO `grantee`@`localhost` |
      +---------------------------------------------+
      1 row in set (0.00 sec)
      
      mysql> SHOW EFFECTIVE GRANTS;
      +----------------------------------------------------------------------------+
      | Effective grants for grantee@localhost                                     |
      +----------------------------------------------------------------------------+
      | GRANT USAGE ON *.* TO `grantee`@`localhost`                                |
      | GRANT ALL PRIVILEGES ON `db2`.* TO `grantee`@`localhost` WITH GRANT OPTION |
      +----------------------------------------------------------------------------+
      2 rows in set (0.00 sec)
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  borys.belinsky Borys Belinsky
                  Reporter:
                  tomislav.plavcic@percona.com Tomislav Plavcic
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 54 minutes
                    54m