0

I haven't used the mySQL permissions mechanism to any great degree & could use a little help while still at the design stage.

Is it possible to grant certain users access only to certain RECORDS within a table (based on the value of a field in those records).

If not, I guess I have to use separate tables or views for each user.

Some initial guidance or links to reference material would be greatly appreciated. TIA

Edit: I am reading the manuals BTW - http://dev.mysql.com/doc/#manual

Edited by haggis-man: found some manuals online

2
Contributors
2
Replies
3
Views
7 Years
Discussion Span
Last Post by haggis-man
1

Is it possible to grant certain users access only to certain RECORDS within a table (based on the value of a field in those records).

No, you can not.

If not, I guess I have to use separate tables or views for each user.

You are right, you have to use views.

0

Many thanks for that mwasif - I dropped off reading the mySQL documentation last night but had pretty much formed that opinion. Good to have it confirmed before setting myself unattainable goals. :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.