Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a section access like this :
Security:
load UPPER(UserCode) as USERID,
"USER" as ACCESS;
select * from G_USAGER;
load "ADMIN" as USERID
"ADMIN" as ACCESS;
section access;
load USERID, ACCESS
resident Security;
section application;
xxxx
xxx
I am only able to log in the application using the ADMIN User .
the others are rejected.
Any idea ?
Thanks a lot
Philippe
I tried UPPER(trim(ACCESS)) AS ACCESS , It works!
Hi,
The section access must be in the top.
In my applications i have a INLINE with Admin rights:
Paste Your User rights here then
//AdminTable
JOIN LOAD * inline [
SERIAL,USERID,PASSWORD,ACCESS
SERIALNUMBER,,,ADMIN
*,USER,PASS,ADMIN];
The Serialnumber is good because i never have to sign in with User, Pass
Hej Philippe
The times I have used section access for users, I had to included the domain name if using NT admin e.g. DOMAIN/Userid.
Do your user ids have the domain in front?
Hi,
I have The Same Problem, is there a solution??
UserTable:
SELECT user AS USERID ,psswd AS PASSWORD , access AS ACCESS
FROM dashboardUsers WITH(NOLOCK);Section Access
load ACCESS,USERID, PASSWORD ;resident UserTable:
I tried UPPER(trim(ACCESS)) AS ACCESS , It works!
Phillipe
Maybe its just cut & paste problem, but I see no FROM statement for the
load "ADMIN" as USERID
"ADMIN" as ACCESS;
clause. Normally this causes the LOAD to use the next statement as the "from" source, but your next statement is the Section Access command, followed by the LOAD RESIDENT for the access load. I think QV might be getting confused at this point.
If that is the case
load "ADMIN" as USERID
"ADMIN" as ACCESS
FROM <where ever this data should be coming from>;
Jonathan
Hi Philippe
Security:
load UPPER(UserCode) as USERID, "USER" as ACCESS;
select * from G_USAGER;
load "ADMIN" as USERID "ADMIN" as ACCESS;
For your code to work
ACCESS, USERID, PASSWORD
These fields needs to be in a single row. From ur code it seems that the ACCESS, USERID & I hope the password comes from a third table G_USAGER needs to be in a single row. Also for concatenating the ADMIN & USER level user's try Concatenate (Security) for ADMIN access. See the table structure as well(Ctrl+T)
Thanks.