On Wed, Jul 31, 2024 at 5:00 PM M Anon <afn24...@gmail.com> wrote: > Thanks Ivan. > > Muchas gracias Manuel. I see you've gone down the route of doing an HA on > the SQL server. Ultimately, that may be the only way to go but I am trying > to avoid that as much as possible (our specific use case really doesn't > justify the complexity of a clustered SQL). > > Anyway, as an update, I've got it to where if the user is authenticated > via LDAP, a user is auto created in the SQL server so that takes care of > the connectivity part. The only part missing now is how do we auto-assign > connection groups to these new user that was created in the DB. More > testing needs to be done. If I get it working, I'll share here. > > At the moment, the best way to accomplish this is to create a group in the database that matches one in LDAP of which the users are members, and assign the rights to that group, making sure that you have enabled LDAP group search/mapping.
-Nick
