I'm new to this whole database thing. Got a uni project which I was hoping y'all could help with.
So I'm creating a webapp that is essentially an online art gallery store. The database will contain an inventory of items and possibly a customer list (this is what I'm not sure about). I want to allow for various levels of manipulation to the inventory list.
I want user 1 let's call that "sales" to add new items, edit and delete. I also want sales to to the same for a customer list. I want user 2 "artists" to be able to add new, edit what they added and delete what they've added to the inventory list, along with their own info. I want user 3 "customer" to be able edit one field in the inventory list (quantity required), along with their own info.
So would this come under rules and privileges?? I want an admin account to oversee the db and all connections. Would I need to create separate rules for all others? Do i add type 1 "sales" as admin with certain rights? Can I contain new users type 2&3 in a customer list and have that list manipulate the inventory list with rules? E.g. So if customer list is type 2, user is an "artist" and can add new stock, but if they are type 3, they are "customer" and can only edit quantity.
Again I am a noob. I hope what I'm asking makes sense. Thanks for your help kind folks.