0

Two things to accomplish:

1) Grant HR employees (Kelly) priviledge to only access HR info.

2) Grant HR manager (Mohammad) priviledge to change HR info.

Parent Table - Departments Child Table - Employee Primary Key (Departments Table) - Dept_ID Foreign Key (Employee Table) - Dept_ID

How should I grant priviledges to certain rows of the table?

Tables

Rows from important columns

Please let me know if I can provide specific information.

Thank you.

Scott Davis
  • 943
  • 5
  • 22
  • 41
  • 1
    Generally speaking, controlling access to db records is *business logic* and is accordingly implemented within the application through which users access the database. If your users have direct access to MySQL (not usually advisable), you might consider using triggers to enforce record-level access control: see [How to set a MySQL row to READ-ONLY?](http://stackoverflow.com/a/10502350) – eggyal Nov 18 '13 at 03:58
  • Yeah, triggers were the only thing I could think of to do this besides preventing direct access. [This post may help](http://stackoverflow.com/questions/4872681) but I think you're going about all this the wrong way. – gloomy.penguin Nov 18 '13 at 04:03

0 Answers0