Questions On Json

So what I’m wanting to do Is create a system that stores usernames roles and what these roles can do most likely in json and save this to a database or is it better to save it to a file? how would I go about creating the best practice for a json. Users would be applying the roles through forms how do I get the form values where I add them into the json?