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
Subject Author Views Date
Thread allow usewrs to view their own records jaspercram 2737 Nov 29, 2002, 6:40 AM
Thread Re: [jaspercram] allow usewrs to view their own records
assombracao 2676 Dec 2, 2002, 8:15 AM
Post Re: [assombracao] allow usewrs to view their own records
jaspercram 2610 Dec 25, 2002, 3:29 AM