By: Peter | July 14, 2016

I have recently started migrating some business systems to MariaDB 10.1.13. One of the reasons was to start using the roles functionality to improve management of security and having some consistent viewpoints of it through the use of roles.


One of the things I found not so well pointed out in the document is the fact you need to be fairly fine grained with the grants. For example granting show databases will leave all tables invisible and inaccessible. You will need to grant select on the database to the role to be able to see the tables within that database.


CREATE ROLE DEVELOPER;

GRANT PROCESS, SHOW DATABASES ON *.* TO 'DEVELOPER';


GRANT ROLE DEVELOPER to `pmclarty`;


Log in as user pmclarty


Set ROLE DEVELOPER;


All I can see in MySQL WorkBench a...

Category: Databases 

Tags: MariaDB, MariaDB Roles 

By: Peter | April 04, 2015

Just wanted to get a better setup that that what I had used after a bit of a drama and pulling down sites last year. Now it may not be wordpress or a lot of other things it could be but for now its stable and it isn't going away and for the initial time it is free. That will do for now.


Looking forward to seeing some old interactions reappear once I get to some regular blogging


See ya round Peter

Category: Site News 

Tags: Peter