Gossamer Forum
Home : Products : DBMan SQL : Pre Sales :

Limiting Access and functions.....client would view and edit ONLY their data....

Quote Reply
Limiting Access and functions.....client would view and edit ONLY their data....
Hi All

I'm thinking that I would like to use DBMan as a way to offer clients access to their data in our system.

However, I need to be certain that the ONLY data that they could view would be their own. They must be restricted right from the start.

They can't have the option of just searching for their items. They cannot view anything but their own.

The entire db would be shared by quite a few clients, and each field could contain data records from many clients.

For example, let's say that the fields are SKU, Title, Size, Color, and Price.

Okay, now Client A has 10 records, Client B has 20 records, etc.

Can DBMan SQL restrict Client A to view/edit only his 10 records?

I guess I could add fields if needed.

Many thanks. Smile

------------------------------------------
Subject Author Views Date
Thread Limiting Access and functions.....client would view and edit ONLY their data.... DogTags 3025 Dec 27, 2002, 3:52 AM
Thread Re: [DogTags] Limiting Access and functions.....client would view and edit ONLY their data....
604 2985 Dec 27, 2002, 10:47 AM
Post Re: [TheStone] Limiting Access and functions.....client would view and edit ONLY their data....
DogTags 2975 Dec 27, 2002, 12:26 PM