MySQL User Privileges - Restrict Users to some tables

Question

I have created a database with several tables, such as user, booking etc.

I have allocated privileges using the User tab within phpmyAdmin, wherein, Users are permitted View and Add privileges, Administrators have View, Add and Amend privileges and Managers have ALL privileges including Delete.

Using the MySQL database, is it possible to do some restrictions as below:

a) Restrict the User to View and Add to only certain tables.

b) Allow the User to view records solely for themselves and not those of any another user.

If so How?

Elumalai Kaliyaperumal · Accepted Answer · 2017-11-27 08:48:01Z

3

You can give privileges to some users to some tables using mysql GRANT as below

GRANT SELECT, INSERT, UPDATE ON db.booking TO 'someuser'@'somehost';

For all privileges use ALL instead of SELECT, UPDATE etc.

GRANT ALL ON db.booking TO 'someuser'@'somehost';

For documentation please go through mysql GRANT

edited Nov 27, 2017 at 8:48

answered Nov 27, 2017 at 8:40

Elumalai Kaliyaperumal

1,5301 gold badge13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL User Privileges - Restrict Users to some tables

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related