Problem restricting user access to specific Database tables using HeidiSql

GowerMick's profile image GowerMick posted 1 year ago in General Permalink

I am a newbie with Mariadb (and heidisql), which I using for multiple Schema, using Libreoffice Base as a front end for each schema, each connection using their own <User>. I have successfully transferred the data into the appropriate schema/tables.

I have successfully restricted each <user> to their own schema and tables, but each user is also given Access to 'Infomation_schema' and 'performance_schema', which I don't want them to see. I can't see a way to revoke access in HeidiSql. (See image)

Any advice would be welcome

1 attachment(s):
  • heidi
ansgar's profile image ansgar posted 1 year ago Permalink

Don't worry, these both are systemic schemata which won't reveal data to which the user has no privilege. You can't restrict access to these both. If you could you would even break some functionality. See them as technical tools for retrieving structural information such as table column types. HeidiSQL also heavily makes use of these, like other tools as well.

You may hide these in HeidiSQL's "Hide database pattern" box, but that's just for keeping it away from the eyes and care for the screen estate:

grafik.png

GowerMick's profile image GowerMick posted 1 year ago Permalink

Ansgar, Thanks, I had realised they were needed by MariaDb to work properly, and your suggestion hides them in Heidisql, but sadly not from my LO Base clients, which is what I wanted.

Please login to leave a reply, or register at first.