How to DROP ROLE in MairaDB

How to DROP ROLE in MairaDB

In MariaDB , you can use below statement to drop the role.

Syntax:
MariaDB > Drop Role RoleName;

Example: 
Let's say if we have a role with name "Role_Select" and we want to drop, we can use below statement.
MariaDB > Drop Role Role_Select;



3 comments:

  1. Hi,

    I'm getting an error like-

    MariaDB [(none)]> use mysql;
    Database changed
    MariaDB [mysql]> select * from roles_mappings;
    ERROR 1146 (42S02): Table 'mysql.roles_mappings' doesn't exist

    Can anyone help?

    ReplyDelete
  2. Got it, It should be select * from roles_mapping;

    ReplyDelete