bravo14 Posted June 26, 2009 Share Posted June 26, 2009 Hi Guys Is it possible to set user permissions on a specific field so that certain users cannot amend the content of the field. Cheers Mark Quote Link to comment https://forums.phpfreaks.com/topic/163734-setting-permissions-on-fields/ Share on other sites More sharing options...
PFMaBiSmAd Posted June 26, 2009 Share Posted June 26, 2009 It would be up to your application code to manage individual (or group) user permissions on a specific field. If you want for example only the person who created the recored and anyone one with higher permissions to be able to modify the record, you would need to do this in your application code. Database permissions are per connection and the permissions set for that connection would apply to all queries executed using that connection. You could for example have a database user defined who can only execute SELECT queries. To use this database user for a specific visitor (of a specific group of visitors) to your site, your application code would need to use a connection with the correct database user at the correct time. Quote Link to comment https://forums.phpfreaks.com/topic/163734-setting-permissions-on-fields/#findComment-863970 Share on other sites More sharing options...
fenway Posted June 27, 2009 Share Posted June 27, 2009 Though mysql does support column privileges. Quote Link to comment https://forums.phpfreaks.com/topic/163734-setting-permissions-on-fields/#findComment-864769 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.