Dharma Mulya
|
| Posted: 10/08/2002, 1:03 AM |
|
Hello all,
Can anyone help me to tackle this problem.
I have two main access tables
1. membership data - contains detail members data (everything that you can
think of).
2. admin data - contains simple admin data (mostly administrator and manager
of a company) and none is included in the membership data.
My objective is
1. The members access level 1 and 2 can access to their database to update
or add data but not delete or browse other members data.
2. Admin level on the other hand can have additional editing function.
I want to have this two tables so that I can control user access but at the
same time I don't have to capture detailed admin data as they are the
company staff.
My question will be - How to have two User access table?
I am using php4, apache, mysql and CC Studio.
Thanks in advance Dharma
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/02
|
|
|
 |
Don Anderson
|
| Posted: 10/09/2002, 4:30 AM |
|
Hi There,
In php to restrict a user to their own data, I set the record component's
query to search against the UserLogin value retrieved by CCGetUserLogin().
That way they can only edit their own record. You can control the delete
using the control options.
Because my admin functions allowed more edit fields than standard users I
decided to make a separate page for admins to alter; one that included
simple search and grid options so admins could find records to edit/delete
etc. You may find this is easier and better than doing ecerything through
the same page?
Best,
Don A
"Dharma Mulya" <dharma@supreme.com.my> wrote in message
news:anu3gu$oku$1@news.codecharge.com...
> Hello all,
>
> Can anyone help me to tackle this problem.
>
> I have two main access tables
> 1. membership data - contains detail members data (everything that you can
> think of).
> 2. admin data - contains simple admin data (mostly administrator and
manager
> of a company) and none is included in the membership data.
>
> My objective is
>
> 1. The members access level 1 and 2 can access to their database to update
> or add data but not delete or browse other members data.
> 2. Admin level on the other hand can have additional editing function.
>
> I want to have this two tables so that I can control user access but at
the
> same time I don't have to capture detailed admin data as they are the
> company staff.
>
> My question will be - How to have two User access table?
> I am using php4, apache, mysql and CC Studio.
>
> Thanks in advance Dharma
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/02
>
>
|
|
|
|
|
