Adding Users to Groups in Security

[RodM]

I am using a grid to add users to the Security framework and everything works well except the users do not get added to the groups. The group list is created from

e.rtc.grouplist = a5ws_get_groups(request,.T.)

the OnGridInitialize event which creates the checkbox list and the code to save is in the AfterInsertRecord event.

dim uservalue as p
dim uservalue.guid as c
dim uservalue.userid as c
dim uservalue.ulink as c
dim uservalue.groups as c
dim uservalue.password as c
uservalue.password = e.DataSubmitted.pin
uservalue.ulink = e.DataSubmitted.QBListID
uservalue.groups = e.DataSubmitted.role.dump()
uservalue.userid = e.DataSubmitted.username
dim output as p
dim output.controls as p
dim output.controls.guid.value as c 
dim result as p
result = a5ws_Save_WebUser_Values(output,uservalue)

As soon as I get this working I will add it to the Update event. Any direction you can give me I will gladly accept. I even changed the e.DataSubmitted.role to a constant and it would not work.

Thanks for your help,

Rod

[MichaelCarroll]

Re: Adding Users to Groups in Security

Rod,

Where did you find notes on e.rtc.grouplist and the security framework?

Michael

[RodM]

Re: Adding Users to Groups in Security

Michael,

The web application functions can be found here http://support.alphasoftware.com/alp..._Functions.htm. Going through the functions will take you to some of the examples.

The e. variable is used extensively in the events.

BTW, using a grid does not work. When I save using the grid, it places the security data in the local or development .dbf. When a dialog is used it places the security data in the web server folder.

Back to attempting to accomplish this through a dialog.

Rod

[JerryBrightbill]

Re: Adding Users to Groups in Security

The security functions require the use of the system "request" variable to properly identify the table location. If the functions are used on a page, or in dialog events, the will add the variable automatically. However, because of the methods used to run the functions in the grid events, the variable must be explicitly assigned.

The release notes for Build 2515-3388 explain what variable to use in various events. For example, the AfterInsert Record event uses "e.GridDefinition.request", so the proper syntax for the security save function would be

a5ws_Save_WebUser_Values(output,uservalue,e.GridDefinition.request)

[RodM]

Re: Adding Users to Groups in Security

Thanks Jerry, I will try it. I had tried using the request variable but was never quite sure how is should be initiated. I will try this tomorrow.

Rod

[RodM]

Re: Adding Users to Groups in Security

Jerry,

Just to let you know that I finally had success. However it took me about 2 hours to get it done. When I initially made the changes the groups field became read only which had never happened before. It was not until I removed the groups field from the grid and then put it back in that it actually worked.

[Andiyanto Bun]

Re: Adding Users to Groups in Security

Hi Rod,

could you please share what you have done for adding user to group in a grid? (screenshot and coding)

currently i am using the exact example from alpha for my security setting in my web application, but i found that if i have many group (let's say 100 group) then when i tried to add a user to group then i will get something strange.

Thanks,
Andy

[Steve Wood]

Re: Adding Users to Groups in Security

If you have 100+- groups you are probably building your application incorrectly. Describe the nature of these groups. The biggest system would still have relatively few groups and the groups would almost never change (renamed, added, deleted) once the application was complete.

[Andiyanto Bun]

Re: Adding Users to Groups in Security

steve, for my case i am a creating accounting system, where i have many tabel and transaction (each transaction and each table master i put on one group, so if i have 40 table master then i will have 40 group), so the administrator can easily to determine for a user to which table and transaction can be authorized to access.

so far i am using example component from alpha five version 9 (dialog component)? and when i save it ,but sometimes it cannot be saved when i click submit (i think because of many group)?

it's why i want to try to use grid instead of dialog in v9 example.

regards,
Andy

[Steve Wood]

Re: Adding Users to Groups in Security

You are closer to the application, but it sounds like two groups, Admin and User. I think if you have to modify security groups based on any data change in the system (addition of a user, a table, etc) that this is an incorrect implementation of security groups.

It would seem more streamlined to have a Users table where each entry had a matching entry in security framework, and when that person logged in, a field in your own Users table would indicate which Master Table they owned.

But you didnt ask that question. Regarding managing secuiry groups in a grid, not sure you can. The security tables are not normally accessible to grids. You could probably build a clone table with all of your groups and then use the web security functions in grid row events to modify the real security tables when a change is made to yours. But that is really just like using the dialog as you are now.

[Andiyanto Bun]

Re: Adding Users to Groups in Security

yes, that's my need actually, i need to use grid for security group rather than using CHECKBOX in dialog component.

could you please share how to clone the table? what step i have to do?

thanks,
andy

[Steve Wood]

Re: Adding Users to Groups in Security

Well I've never done it, but I meant create a table with a single field for Groups and add all of your security groups in the table, one record for each. Then review the Help at the address below to use the functions to add or remove a security group using grid events. I don't know if this is a good or a bad idea, but it's worth trying.

http://support.alphasoftware.com/Wha...Event Handlers

[Andiyanto Bun]

Re: Adding Users to Groups in Security

hi rod,

could you share what you did with security group on a grid?

Thanks,
Andy

[RodM]

Re: Adding Users to Groups in Security

Andiyanto,

My apologies, I did not follow this thread and just saw this request. I attached a simple grid that works. It will not work until published but feel free to take the concepts.

Rod

[Andiyanto Bun]

Re: Adding Users to Groups in Security

Hi Rod,

Many thanks for your reply. i will take a look at it.

Regards,
Andy