CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 How I can restrict Customers to access their Grouping Items only?

Print topic Send  topic

Author Message
Malik
Posted: 05/16/2001, 4:38 AM

Dear All + Support,

I am working on a project where I have to build a Sales Entry System using
Access database at backend. The site would be secured and there is Groups
say A, B, C and all these groups belong to specific Product ID. In
otherword, GroupID would be the key which let Customers to see only listed
products in that particular category. I have gone through your example of
Bookstore (I need similar thing) but with addition that Customers shall be
able to see and select their categories (not full Product list).

Question seems very weird when I ask how to do it? I know this require quite
patience to answer this - nonetheless I will appreciate if someone of you
spare some time and guide me what extra steps I have to take in Bookstore
Demo.

Thanks a lot to all who went through my request.

Malik

Alexey Alexapolsky
Posted: 05/16/2001, 8:32 AM

How do you store this information in a database ?
I mean does customer have field "group" that contains
comma separated names of groups , or customer record
contains boolean fields "belongsToA" , "belongsToB" etc.


--
Regards,
Alexey
CodeCharge Support



Malik <n.malik@usa.net> wrote in message
news:9dtoqn$g7i$1@mail.tankhill.com...
> Dear All + Support,
>
> I am working on a project where I have to build a Sales Entry System using
> Access database at backend. The site would be secured and there is Groups
> say A, B, C and all these groups belong to specific Product ID. In
> otherword, GroupID would be the key which let Customers to see only listed
> products in that particular category. I have gone through your example of
> Bookstore (I need similar thing) but with addition that Customers shall be
> able to see and select their categories (not full Product list).
>
> Question seems very weird when I ask how to do it? I know this require
quite
> patience to answer this - nonetheless I will appreciate if someone of you
> spare some time and guide me what extra steps I have to take in Bookstore
> Demo.
>
> Thanks a lot to all who went through my request.
>
> Malik
>
>

Malik
Posted: 05/16/2001, 1:48 PM

I guess I have to send you Access Tables where you can find your answer.

Thanks for quick response.

Malik
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9du6j0$v6a$1@mail.tankhill.com...
> How do you store this information in a database ?
> I mean does customer have field "group" that contains
> comma separated names of groups , or customer record
> contains boolean fields "belongsToA" , "belongsToB" etc.
>
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
>
> Malik <n.malik@usa.net> wrote in message
>news:9dtoqn$g7i$1@mail.tankhill.com...
> > Dear All + Support,
> >
> > I am working on a project where I have to build a Sales Entry System
using
> > Access database at backend. The site would be secured and there is
Groups
> > say A, B, C and all these groups belong to specific Product ID. In
> > otherword, GroupID would be the key which let Customers to see only
listed
> > products in that particular category. I have gone through your example
of
> > Bookstore (I need similar thing) but with addition that Customers shall
be
> > able to see and select their categories (not full Product list).
> >
> > Question seems very weird when I ask how to do it? I know this require
> quite
> > patience to answer this - nonetheless I will appreciate if someone of
you
> > spare some time and guide me what extra steps I have to take in
Bookstore
> > Demo.
> >
> > Thanks a lot to all who went through my request.
> >
> > Malik
> >
> >
>
>

Jim Bombardo
Posted: 05/23/2001, 12:28 PM

I am also trying to accomplish this. I am using MySql and the data bases
contain a field that identifies which group they belong to.
"Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
news:9du6j0$v6a$1@mail.tankhill.com...
> How do you store this information in a database ?
> I mean does customer have field "group" that contains
> comma separated names of groups , or customer record
> contains boolean fields "belongsToA" , "belongsToB" etc.
>
>
> --
> Regards,
> Alexey
> CodeCharge Support
>
>
>
> Malik <n.malik@usa.net> wrote in message
>news:9dtoqn$g7i$1@mail.tankhill.com...
> > Dear All + Support,
> >
> > I am working on a project where I have to build a Sales Entry System
using
> > Access database at backend. The site would be secured and there is
Groups
> > say A, B, C and all these groups belong to specific Product ID. In
> > otherword, GroupID would be the key which let Customers to see only
listed
> > products in that particular category. I have gone through your example
of
> > Bookstore (I need similar thing) but with addition that Customers shall
be
> > able to see and select their categories (not full Product list).
> >
> > Question seems very weird when I ask how to do it? I know this require
> quite
> > patience to answer this - nonetheless I will appreciate if someone of
you
> > spare some time and guide me what extra steps I have to take in
Bookstore
> > Demo.
> >
> > Thanks a lot to all who went through my request.
> >
> > Malik
> >
> >
>
>

Dr. Scott R. Senay
Posted: 05/25/2001, 7:28 PM

What you are in essence trying to do is implement a security system with in
a security system. Code charge has very funtional security which if used
exactly as is will limit you to three security levels, HOWEVER you are NOT
forced to stay with just three. Let's say for argument sake you have three
groups of users, group a, group b and group c. With in each group you have
three different security levels, guest, member and admin. As I understand
you question you DON'T the admins from the other two groups to have access
etc...

So, what you essentially would do is USE the security system as is, expand
to nine levels, and beak up those nine into three groups of three. Finally
build your application for the first group, test it and verify that it is
working for the first group as expected. All data and operations would be
based on the central database. When the system works exactly as desired for
Group A, simply then create a super project with a master login section,
import group a, change it to group b, import group a again and turn it into
group c, lastly import group a and leave as is. Changing Group A to B and C
is simply a matter of changing the security level(s) it responds to and
making a minor change to the form names. What you then have is three
complete systems WITHIN a system that acts as a switcher. Viola! You have
just built a system with three groups of security and one master backend
database... If you REALLY want to make you life harder (actually easier)
you build a fourth group that has MASTER system access and can see and touch
everything, this will be your maintenance and security team...

If you have questions or problems please feel free to stop in at
http://www.conceptech.com/support and submit a request... The system there
should look familar, it's the CodeCharge master support system re-tuned and
working quite well in PHP...

Sincerely,


Dr. Scott Robert Senay
VP R&D Conceptech.


Malik <n.malik@usa.net> wrote in message
news:9dup2k$js3$1@mail.tankhill.com...
> I guess I have to send you Access Tables where you can find your answer.
>
> Thanks for quick response.
>
> Malik
> "Alexey Alexapolsky" <alexa@codecharge.com> wrote in message
>news:9du6j0$v6a$1@mail.tankhill.com...
> > How do you store this information in a database ?
> > I mean does customer have field "group" that contains
> > comma separated names of groups , or customer record
> > contains boolean fields "belongsToA" , "belongsToB" etc.
> >
> >
> > --
> > Regards,
> > Alexey
> > CodeCharge Support
> >
> >
> >
> > Malik <n.malik@usa.net> wrote in message
> >news:9dtoqn$g7i$1@mail.tankhill.com...
> > > Dear All + Support,
> > >
> > > I am working on a project where I have to build a Sales Entry System
> using
> > > Access database at backend. The site would be secured and there is
> Groups
> > > say A, B, C and all these groups belong to specific Product ID. In
> > > otherword, GroupID would be the key which let Customers to see only
> listed
> > > products in that particular category. I have gone through your example
> of
> > > Bookstore (I need similar thing) but with addition that Customers
shall
> be
> > > able to see and select their categories (not full Product list).
> > >
> > > Question seems very weird when I ask how to do it? I know this require
> > quite
> > > patience to answer this - nonetheless I will appreciate if someone of
> you
> > > spare some time and guide me what extra steps I have to take in
> Bookstore
> > > Demo.
> > >
> > > Thanks a lot to all who went through my request.
> > >
> > > Malik
> > >
> > >
> >
> >
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.