Alpha DevCon 2018
Results 1 to 7 of 7

Thread: Web Security Groups list

  1. #1
    Member
    Real Name
    Keith Stansbury
    Join Date
    Sep 2013
    Posts
    84

    Default Web Security Groups list

    Is there a way to get a list/grid of

    userID and checkboxes for the different security groups.

    something like this:

    userID Admin Finance Manager AnotherGroup

    user01 x x x x
    user02 _ _ x
    user03 _ _ _ x
    Last edited by kstans; 12-27-2017 at 10:30 AM.

  2. #2
    "Certified" Alphaholic mikeallenbrown's Avatar
    Real Name
    Mike Brown
    Join Date
    Nov 2009
    Location
    United States
    Posts
    1,505

    Default Re: Web Security Groups list

    Alpha has some built in templates for handling user security. Have you already looked at them?
    Mike Brown - Contact Me
    Programmatic Technologies, LLC
    Programmatic-Technologies.com
    Independent Developer & Consultant

  3. #3
    Member
    Real Name
    Keith Stansbury
    Join Date
    Sep 2013
    Posts
    84

    Default Re: Web Security Groups list

    Yes. There is not a template to do what I need. I cant see how to tie groups and users together on one row.

  4. #4
    Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,786

    Default Re: Web Security Groups list

    I think we have all done this in the past in a Detail section, one user at a time (see image). But I can see how it can be done in rows, or at least I could try. Do you want real checkboxes so the Admin can toggle a user in and out of a group with a simple checkbox?
    Attached Images Attached Images
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  5. #5
    Member
    Real Name
    Rich Fulham
    Join Date
    May 2011
    Location
    Portland, OR
    Posts
    822

    Default Re: Web Security Groups list

    Assuming you have migrated your web security tables to SQL, you should be able to create a cross tab query for use in a LIST on a UX.

    It is possible to make the data updateable, but you have to code all the update code yourself by picking apart the submitted LIST data.

    I was talking to someone at a AA conference a couple years ago that had turned their crosstab query from a LIST into something that could write changes back to the DB.

  6. #6
    Former Alpha Employee JerryBrightbill's Avatar
    Real Name
    Jerry Brightbill
    Join Date
    Apr 2000
    Posts
    5,162

    Default Re: Web Security Groups list

    You should never access security tables directly, but should only use security function such as a5ws_* functions or the Context.Security methods. The Context.Security methods are preferred as they are native to IIS, are fully supported on the standard server, and will work in all authentication systems including Active Directory.

    There are a number of reasons for this as the built in methods include special provisions for data validation and data integrity. Since they are supported on both IIS and the standard server, you can switch from one server to the other with no changes. If you edit the data directly, it is quite possible to cause a data corruption problem that cannot be corrected, resulting in a unusable security system.

    It is possible to get a list of the roles for a user with relatively simple xbasic if all you want to do is view the roles. You can use methods such as Context.Security.GetUsers() to get a list of users, and then Context.Security.GetUserRoles to find their roles. This could be done in a simple array and then output to a list if using a UX

  7. #7
    Member
    Real Name
    Keith Stansbury
    Join Date
    Sep 2013
    Posts
    84

    Default Re: Web Security Groups list

    Yes a list of users, with a list of check boxes

    Each user would have his own row. And each row would have a check box for each security group.

    That would be ideal if there is a way to make that happen.

Similar Threads

  1. How to list user's Security Groups selected for Live Preview for a UX
    By RichCPT in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 09-26-2017, 04:59 PM
  2. Security Groups
    By PaulStringer in forum Mobile & Browser Applications
    Replies: 1
    Last Post: 03-10-2015, 08:47 AM
  3. Panel Navigator list doesn't honor 'security groups' settings
    By cemopolat in forum Mobile & Browser Applications
    Replies: 8
    Last Post: 06-10-2014, 02:08 PM
  4. Security groups
    By eribla in forum Application Server Version 11 - Web/Browser Applications
    Replies: 5
    Last Post: 12-01-2011, 07:22 PM
  5. Code to list security groups for all A5W pages
    By Steve Wood in forum Code Archive
    Replies: 1
    Last Post: 05-28-2008, 01:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •