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!

asked 09 Apr, 10:17

dharrel's gravatar image

dharrel
41115
accept rate: 0%

Did you read this article in the SQL Anywhere Wiki?

(10 Apr, 05:37) Vlad

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?

(12 May, 13:18) dharrel
Replies hidden
2

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.

(13 May, 03:00) Volker Barth
Be the first one to answer this question!
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • 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:

×3

question asked: 09 Apr, 10:17

question was seen: 161 times

last updated: 13 May, 03:01