linux-traipu team mailing list archive

[Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx>]

Seems like you could indeed just transform all the regexps to case
insensitive, since all objects are that too. I don't think an option is
even needed. (Or can be added later.)

This is clearly low-hanging-fruit

** Tags added: low-hanging-fruit

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/956153

Title:
  regex_policy patterns are case-senstive

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Confirmed

Bug description:
  regex_policy plugin patterns are case-senstive but Drizzle is not
  case-senstive.

  To reproduce:

  1. create schema daniel
  2. Use policy "daniel schema=daniel ACCEPT"
  3. Login user=daniel and schema appears, OK, but...
  4. Use policy "daniel schema=DANIEL ACCEPT" _or_ "DANIEL schema=daniel ACCEPT"
  5. Login user=daniel and schema does not appear

  Suggested fix: make all patterns case-insenstive by default.  Maybe
  add an option: --regex-policy.case-senstive if there's a need for
  case-sensitivity?

  Partial workaround:

  daniel schema=daniel ACCEPT
  daniel schema=DANIEL ACCEPT

  That doesn't cover schema=Daniel, schema=DaNiEl, etc.

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/956153/+subscriptions