CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeCharge.Discussion

 Security Clue needed.

Print topic Send  topic

Author Message
kmc
Posted: 03/05/2001, 5:17 PM

Beginner - first day with purchased copy - need a clue to proceed with
individual security accesses.

CC has security levels but I need to show data according to individual user
login id -
of which there may be 100's of users.

Given I have a Users table to verify login id/passwd, then I need to pass
the user login-id to a Search/Grid/Edit
page that shows only the records where login-id is keyed within those
records,
i.e. the login-id key is a foreign key in the main table identifying the
owner of the record.

E.g. login-id is "bwoodston", has a key of "5" in User table

Table "Projects" has in it's proj_manager field a foreign key of "5" to
indicate the project manager is "bwoodston".
When he/she logs in, cannot see any other records other than their own.

Effectively I need to run query ....."where proj_manager = {login-id}"...
when the main page Search/Grid/Edit is opened on a successful verification
of
userid/password.

The security levels in CC don't seem appropriate for my case here.

Clues and locations for code insertions anyone?

Thanks.

kmc




Laurence Nixon
Posted: 03/05/2001, 9:19 PM

Well im not exactly sure how or where you would write this at the moment but
what your looking to do is:
if user = databasetableuser and password=databasetable password and
level=databaselevel then (action)
Else next (until desired level is found and appropriate resource is accessed)

I know I ran across this very same architecture on www.4guysfromrolla.com, go
there and do a search on user authentication. Or goto
http://www.hotscripts.com/ASP/Scripts_and_Components/User_Authentication/
Youll find what you need there.



kmc wrote:

> Beginner - first day with purchased copy - need a clue to proceed with
> individual security accesses.
>
> CC has security levels but I need to show data according to individual user
> login id -
> of which there may be 100's of users.
>
> Given I have a Users table to verify login id/passwd, then I need to pass
> the user login-id to a Search/Grid/Edit
> page that shows only the records where login-id is keyed within those
> records,
> i.e. the login-id key is a foreign key in the main table identifying the
> owner of the record.
>
> E.g. login-id is "bwoodston", has a key of "5" in User table
>
> Table "Projects" has in it's proj_manager field a foreign key of "5" to
> indicate the project manager is "bwoodston".
> When he/she logs in, cannot see any other records other than their own.
>
> Effectively I need to run query ....."where proj_manager = {login-id}"...
> when the main page Search/Grid/Edit is opened on a successful verification
> of
> userid/password.
>
> The security levels in CC don't seem appropriate for my case here.
>
> Clues and locations for code insertions anyone?
>
> Thanks.
>
> kmc
Laurence Nixon
Posted: 03/05/2001, 9:22 PM


http://www.programmersresource.com/articles/login_system.asp
Laurence Nixon wrote:

> Well im not exactly sure how or where you would write this at the moment but
> what your looking to do is:
> if user = databasetableuser and password=databasetable password and
> level=databaselevel then (action)
> Else next (until desired level is found and appropriate resource is accessed)
>
> I know I ran across this very same architecture on www.4guysfromrolla.com, go
> there and do a search on user authentication. Or goto
> http://www.hotscripts.com/ASP/Scripts_and_Components/User_Authentication/
> Youll find what you need there.
>
> kmc wrote:
>
> > Beginner - first day with purchased copy - need a clue to proceed with
> > individual security accesses.
> >
> > CC has security levels but I need to show data according to individual user
> > login id -
> > of which there may be 100's of users.
> >
> > Given I have a Users table to verify login id/passwd, then I need to pass
> > the user login-id to a Search/Grid/Edit
> > page that shows only the records where login-id is keyed within those
> > records,
> > i.e. the login-id key is a foreign key in the main table identifying the
> > owner of the record.
> >
> > E.g. login-id is "bwoodston", has a key of "5" in User table
> >
> > Table "Projects" has in it's proj_manager field a foreign key of "5" to
> > indicate the project manager is "bwoodston".
> > When he/she logs in, cannot see any other records other than their own.
> >
> > Effectively I need to run query ....."where proj_manager = {login-id}"...
> > when the main page Search/Grid/Edit is opened on a successful verification
> > of
> > userid/password.
> >
> > The security levels in CC don't seem appropriate for my case here.
> >
> > Clues and locations for code insertions anyone?
> >
> > Thanks.
> >
> > kmc
CodeCharge
Posted: 03/05/2001, 11:42 PM

Hi,

I think that you may not be able to do this today directly in CodeCharge,
but tomorrow we're releasing a new version that will contain additional
events, and you may use OnLogin Event in login form:
if bPassed then
if sLogin="Joe" then response.redirect("joe.asp")
end if

Additionally, you will be able to completely replace CodeCharge
Authentication function with your own.

Adam Stock
CodeCharge Support


"kmc" <kmcook@tasmail.com> wrote in message
news:981dqb$8uv$1@mail.tankhill.com...
> Beginner - first day with purchased copy - need a clue to proceed with
> individual security accesses.
>
> CC has security levels but I need to show data according to individual
user
> login id -
> of which there may be 100's of users.
>
> Given I have a Users table to verify login id/passwd, then I need to pass
> the user login-id to a Search/Grid/Edit
> page that shows only the records where login-id is keyed within those
> records,
> i.e. the login-id key is a foreign key in the main table identifying the
> owner of the record.
>
> E.g. login-id is "bwoodston", has a key of "5" in User table
>
> Table "Projects" has in it's proj_manager field a foreign key of "5" to
> indicate the project manager is "bwoodston".
> When he/she logs in, cannot see any other records other than their own.
>
> Effectively I need to run query ....."where proj_manager = {login-id}"...
> when the main page Search/Grid/Edit is opened on a successful verification
> of
> userid/password.
>
> The security levels in CC don't seem appropriate for my case here.
>
> Clues and locations for code insertions anyone?
>
> Thanks.
>
> kmc
>
>
>
>
>


   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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