|
I see how we can authenticate SQL Anywhere users using an LDAP server. My question is: Can we obtain in SQL Anywhere code the LDAP Group that the authenticated user is a member of? More generally, can anyone provide any guidance on querying LDAP server data from SQL Anywhere code? Thanks! |
Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.
Follow this question
By Email:Once you sign in you will be able to subscribe for any updates here
By RSS:Markdown Basics
- *italic* or _italic_
- **bold** or __bold__
- link:[text](http://url.com/ "title")
- image?
- numbered list: 1. Foo 2. Bar
- to add a line break simply add two spaces to where you would like the new line to be.
- basic HTML tags are also supported
Question tags:
question asked: 09 Apr '20, 10:17
question was seen: 1,107 times
last updated: 13 May '20, 03:01
Did you read this article in the SQL Anywhere Wiki?
Thanks. It's not what I'm looking for, though. I'm looking for an LDAP API that can be easily called from SQL Anywhere stored procedure code. I need to query LDAP data.
Can anyone refer me to such an LDAP API?
Well, SQL Anywhere supports stored functions and procedures using external calls - among others in C, so you could call any LDAP C API from SQL Anywhere, e.g. that from the MS Windows SDK, or APIs in the other languages supported by external calls (.NET, Java, JavaScript, Perl, PHP). However, writing external functions/procedures is usually not that easy...
Probably it would be easier to use cmd_shell to call an according LDAP command line tool to do the actual LDAP query and analyze its output within the database server.
Note: I have not tried any of the above but have both worked with external C calls and calling cmd_shell.