Is there a way (SQL Anywhere v11) to allow a custom authentication?

I'd like to allow a userid and password to be authenticated via LDAP.

Since the LDAP users can change daily it would be ideal if the Sybase user did not have to exist prior to the login. It's too much overhead to maintain users in both databases. I'd like to either add a user at that point or simply set all the "permissions and authorities" and move on.

I looked into the login_procedure option but it looks like at that point the connection has already been authenticated and the only option is to cancel.

Thank you for any suggestions.

asked 24 Aug '10, 16:05

Integrated%20Login's gravatar image

Integrated L...
106344
accept rate: 0%

edited 11 Jan '14, 07:59

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109


Update: LDAP user authentication is now supported as of SQL Anywhere version 16.0.0. Documentation is here.

SQL Anywhere doesn't currently support LDAP User Authentication, although that is a feature we are considering for a future version.

You may be able to accomplish what you want using either Integrated Login or Kerberos support. Basically, depending on the configuration, they can authenticate the user logged into the Windows OS or Kerberos system (which includes Windows ActiveDirectory) and allow the user to login to the server without supplying a userid or password (instead the system passes and verifies their OS user credentials). You need to setup a mapping for each OS/Kerberos user or create the special guest database user as a catch-all for users that don't have explicit mappings.

See Integrated logins and Kerberos in the documentation for more info.

permanent link

answered 24 Aug '10, 20:43

Ian%20McHardy's gravatar image

Ian McHardy
3.1k23353
accept rate: 39%

edited 09 Jan '14, 15:14

Graeme%20Perrow's gravatar image

Graeme Perrow
8.5k371109

Your answer
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:

×19
×2

question asked: 24 Aug '10, 16:05

question was seen: 944 times

last updated: 11 Jan '14, 07:59