Skip to content

'delete history' (mariadb 10.3.x) privilege missing / cannot revoke all priv. on db #1026

@neftha

Description

@neftha

Steps to reproduce this issue

  1. Step 1;
    Have a DB user with some grants, e.g.
    GRANT ALL PRIVILEGES ON example.* TO 'exampleuser'@'localhost'
  2. Step 2;
    Revoke permissions on database using Heidisql - user -> permissions dialoge

Current behavior

The new "delete history" permission (since Mariadb 10.3.4) is not shown in HeidiSQL and cannot be revoked.
Revoking all permissions in the GUI = database still listed in the user->permisson dialog.

There are still permissions left, that cannot be accessed or deleted using the permisson dialog:
GRANT DELETE HISTORY ON example.* TO 'exampleuser'@'localhost'

Expected behavior

(1) permission checkbox for 'delete history'
(2) revoking all permissions on a database should work (=main issue)

Environment

  • HeidiSQL version:
    11.0.0.5977
  • Database system and version:
    MariaDB 10.3.22
  • Operating system:
    Windows 10

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugDefective behaviour in HeidiSQLconfirmedIssue verified by project membernettype-mysqlMySQL and/or MariaDB specific issue

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions