Hi,
I know there is a way in DBMan SQL that allows users to view and/or modify the records which they own. This is checked by verifying that the value in a certain column is equal to the current username. As my database is setup in a relational way, the username of the owner is in a different table then the table they are allowed to view.
For example: I have the following tables:
Books: Id, authorid
Authors: Id, username
I would like to specify that authors can only modify their own books. Does anyone know if this is possible? If not, what would be an easy and general (so that other people can use it as well) way to accomplish it?
Thanks, Jasper
http://www.bookings.org
I know there is a way in DBMan SQL that allows users to view and/or modify the records which they own. This is checked by verifying that the value in a certain column is equal to the current username. As my database is setup in a relational way, the username of the owner is in a different table then the table they are allowed to view.
For example: I have the following tables:
Books: Id, authorid
Authors: Id, username
I would like to specify that authors can only modify their own books. Does anyone know if this is possible? If not, what would be an easy and general (so that other people can use it as well) way to accomplish it?
Thanks, Jasper
http://www.bookings.org