Gossamer Forum
Home : Products : DBMan SQL : Discussion :

allow usewrs to view their own records

Quote Reply
allow usewrs to view their own records
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
Quote Reply
Re: [jaspercram] allow usewrs to view their own records In reply to
Hello Jasper

Maybe You can define the user who owns the record for the books table too

Fábio
Quote Reply
Re: [assombracao] allow usewrs to view their own records In reply to
Thanks for the suggestion, but I am afraid that in my situation, it would introduce too much redundancy in my database.

GT, any suggestion?

Thanks, Jasper

http://www.bookings.org