hello!

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?

please give me some pointers!


even then how will i make

I have something similar to what you want on my site.

Let me find the code...

I have a table called usergroup. It has a groupid, for example groupid "1" is administrators.

In the users table i would have a collumn called level, which for ME would contain the level "1" (the super admin level).

Then it selects my level from the table usergroups and checks if my permissions = yes

ie
etc

Excuse messy coding, only 14 years old lmao.


But still its easy to do. If you need any more help then just reply, if i have posted the wrong response feel free to spam me lmao

Oh and you would have the default table values for permissions such as logout as yes. :P