Steve1445
Posts: 16
|
| Posted: 10/20/2006, 1:32 PM |
|
Besides users entering their own passwords to access their own records, is there a way to allow a supervisor to have a master password to access multiple records without having to look up each user's password?
|
 |
 |
wkempees
Posts: 1679
|
| Posted: 10/20/2006, 3:08 PM |
|
That all depends on your SQL, I think.
Probably you mean that after login you present some grid displaying only records that belong to the loggedin user.
SELECT..... FROM .... WHERE ....... UserId={UserID} type Session
If you want to have a SuperUser (Visor) the that account would have to have either the highest accesslevel possible (if you use the option in Accesscontrol that governs higher levels to include lower levels) AND you need to tell the SQL what to do if AccessLevel is that value.
My approach qould be to have an identifyable GroupID.
In BeforeExecuteSelect you could then modify the Where.
If you keep the UserId={UserID} last in the Where, you could substitute that part by a blank, in effect removing the UserID = .
Or using a if-then-else construct modify the SQL
The easiest approach though is:
on the page have two Grids, exactly the same lay-out one with and the other without the UserID= part in the Where.
Set the one to visible No the other to Yes
In BeforeShowPage check the GroupID and depending on it being Super or not, exchange the visibility.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 10/20/2006, 3:10 PM |
|
Using Panels, is the nicest user experience and easiest to do.
(late thought)
But the visible property is available on Grids.
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
