Should database users also have access to mysql, information_schema & performance_schema tables?

Question

So I have for example a table in my database called "Test", I have created a user with SELECT,INSERT & UPDATE only privileges. This user will be inserting data to the database. Should this user be limited to only having access to the "Test" table or should they also have access to the 3 tables mentioned above?(obviously these tables come standard with mariadb). Sorry probably a silly question but just want to be sure

Is this a question about principle (_should_)? Or are you asking whether a user _does_ have access to these 3 databases? — Rick James, May 19 '19 at 04:18

score 1 · Accepted Answer · answered May 01 '19 at 22:50

1

If a user is restricted with grants to particular database/tables, they will only see those tables.

answered May 01 '19 at 22:50

danblack

12,130
2
22
41

Should database users also have access to mysql, information_schema & performance_schema tables?

1 Answers1