Re-enable authentication with session user instead of scope user in protegrity

Details

Detail name Value
Changelog Number 6883
Type Bug
Status Resolved
Affected Versions EXASOL 6.0.9
Fix Versions Exasol 6.1.0, Exasol 6.0.13
Resolution Date 2018-10-19

In Exasol 6.0.9 the behavior of the Protegrity plugin has been changed to use the view owner (if present) instead of the session user for authentication against the Protegrity server. This change does not work for all our customers. In order to not break existing use cases, we will create two versions of the plugin:

  • udfplugin_protegrity: uses view owner for authentication
  • udfplugin_protegrity_ua: uses session user for authentication
    Users can choose the desired behavior by giving the corresponding ALTER SESSION command:
  • ALTER SESSION SET SCRIPT_LANGUAGES='PYTHON=builtin_python R=builtin_r JAVA=builtin_java PROTEGRITY=udfplugin:///protegrity'
  • ALTER SESSION SET SCRIPT_LANGUAGES='PYTHON=builtin_python R=builtin_r JAVA=builtin_java PROTEGRITY=udfplugin:///protegrity_ua'