im creating a webdatabase program thats kind of like flickr
im abit stuck and could really use some help! so thanks in advanced!
ive managed to get session authentication through username password verification from a table in the database.
im abit confused now, as it seems i need to grant every user specifically with rights to do certain things.
say i want users to only be able to edit their own photos but view all photos , how do i do this? andif i give them that access will they not be able to view all the data from say the user tables which isnt good?
i assume the best way would be to write some php code that will selfcode the GRANT SELECT etc etc for each user during the registration step?