2. ASPRunnerPro General questions
  3. [SOLVED]  Wildcard match in security log-in key
This topic is locked
[SOLVED]

 Wildcard match in security log-in key

 		11/19/2009 10:41:03 AM
ASPRunnerPro General questions
Stu author

I use a customer log-in with the security settings so that the referencing ID to match with the root table is a unique Company Code. This displays all their Branches.
For example:-
LogName: Tesco

Pwd: 1235

ID: tescoroot
So, I list all Branches that have a Company Record related to the key "tescoroot".
But I want a global log-in for our engineers so they can look at all Companies and Branches
I created something like:-
LogName: engineers

Pwd: 99999

ID: *
Hoping that it would wildcard match with all keys - but it doesn't.
Can you suggest a way I can implement a wildcard log-in. Also, I guess I can reference who is logged-in later in teh code so I can give privelieges to "engineers" that customers don't have. Briefly, what code references the logged-in users?
Thanks
J
 		Jane 11/20/2009

Hi,
just grant admin permissions to engineers on the User group permissions dialog on the Security tab (for static permissions) or in the admin area (for dynamic permissions).
Stu author 11/23/2009

Jane,
Thanks for the reply but it doesn't work for me.
The username that logs-in has an associated key that defines the set of Companies that user is allowed to see. Security is "Users can only see and edit their own data.
When "engineers" log-on they must also have a key associated with the scope of Companies they are allowed to view as it comes from the same table as customers use for security. In their case its ALL Companies I want them to see and edit.
Hence, I tried to set their key to "*" hoping it was a wildcard match.
I can set engineers permissions on what they are allowed to do but can't make them see ALL Companies.
Stu author 11/24/2009

Jane,
I could achieve my aims if in the Query design page I could include a filter that is something like:-
[Company Key Field] Like Session("Owner ID Field")
That is that the records from the Master Company table are restricted to the ID field associated with the logged-in user.
I know that you do this in "Advanced Security Settings" but I have the feeling you apply an "=" test and I want a "Like" test so that the wildcard ID "*" matches ALL records.
Another way of expressing it is "How do I limit the Master Table" to the logged-on user when the the logged-on user will indicate a key ID held in another table which is the filter to use for the Master Company Table?
Stu author 11/24/2009

Apologies Jane.
I've been stoopid. I watched the security video tutorial and now I understand. I just need to create a grooup filed for my users.
In fact its brilliant!
Solved!