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
Jump to PostIs 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 …
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.
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. :)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.