Menu

#2320 (ok 2.9.2) Deleting user with GRANT option fails

2.9.1.1
fixed
Privileges (64)
1
2013-06-11
2006-12-12
No

Deleting a user that has the GRANT option set via the "Remove selected users" option fails because the GRANT option is not unset with a REVOKE ALL PRIVILEGES.

This can f.e. be observed when trying to remove the root@thishost user.

The used query

REVOKE ALL PRIVILEGES ON * . * FROM 'user'@ 'hostname';
DROP USER 'user'@ 'hostname';

is insufficient. Adding a

REVOKE GRANT OPTION ON * . * FROM 'user'@ 'hostname';

before the DROP USER should fix this.

Discussion

  • Marc Delisle

    Marc Delisle - 2006-12-21
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2006-12-21

    Logged In: YES
    user_id=210714
    Originator: NO

    Which MySQL version are you using?

     
  • Anonymous

    Anonymous - 2007-01-02

    Logged In: YES
    user_id=1585413
    Originator: YES

    Sorry I didn't mention this:

    mysql-4.1.20-1.RHEL4.1 (CentOS 4)

     
  • Marc Delisle

    Marc Delisle - 2007-01-02
    • priority: 5 --> 1
    • summary: Deleting user with GRANT option fails --> (ok 2.9.2) Deleting user with GRANT option fails
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2007-01-02

    Logged In: YES
    user_id=210714
    Originator: NO

    Fixed for 2.9.2

     
  • Marc Delisle

    Marc Delisle - 2007-01-16
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed