Postgres has a wide array of supported authentication methods. The strongest methods have trouble scaling across large numbers of database instances, though, and while organizations have ways to centralize user credentials -- for example by using LDAP or Kerberos -- those solutions come with their own large lists of caveats.I'm currently developing Postgres-native support for OAuth, which is a widely-deployed framework for authorizing clients using a third-party provider. I'll talk about the current state of the patchset, explain some of the elements of the design, and demonstrate what it might look like to deploy it yourself.
Tags: postgres, postgresql, oauth
Imported from: http://calagator.org/events/1250481749
-