# why do grants switch from granular to ALL after granting "lock tables"

**URL:** <https://forums.percona.com/t/why-do-grants-switch-from-granular-to-all-after-granting-lock-tables/8199>\
**Category:** Percona Server for MySQL 8.0\
**Created:** [October 27, 2020, 1:08pm UTC](https://forums.percona.com/t/why-do-grants-switch-from-granular-to-all-after-granting-lock-tables/8199 "2020-10-27T13:08:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![grosenthal](https://avatars.discourse-cdn.com/v4/letter/g/e47c2d/32.png) [@grosenthal](https://forums.percona.com/u/grosenthal)\
**Post date:** [October 27, 2020, 1:08pm UTC](https://forums.percona.com/t/why-do-grants-switch-from-granular-to-all-after-granting-lock-tables/8199/1 "2020-10-27T13:08:04Z")

</div>

We have a role with all these permissions.

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, REFERENCES, INDEX, ALTER, CREATE TEMPORARY TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EVENT, TRIGGER ON db.\* to rolea

As soon as i grant ‘lock tables’ to the role it no longer displays individual roles after executing show grants. It now simply says grant all privs

GRANT ALL PRIVILEGES ON db.\* to rolea

Any idea why?

±----------+

| @@version |

±----------+

| 8.0.21-12 |

±----------+

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [October 29, 2020, 11:36am UTC](https://forums.percona.com/t/why-do-grants-switch-from-granular-to-all-after-granting-lock-tables/8199/2 "2020-10-29T11:36:46Z")

</div>

I imagine this is a simple code check within core mysql. If you have all the flags then display ‘ALL’ otherwise show them individually. Have you tried using pt-show-grants instead? I believe this tool will show you all individual flags.