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
>
>
>
>
>
|
|
|
|
|
